open office calc help

Home Forum Chat Forum open office calc help

Viewing 3 posts - 1 through 3 (of 3 total)
  • open office calc help
  • Premier Icon nickjb
    Subscriber

    I’ve got a worksheet with various columns. One of the columns is a catogory, I want to sum one of the columns for all items in the same catagory. eg

    A 1
    A 2
    B 7
    C 5
    A 6
    B 6

    would give A=9, B=13, C=5

    Is this possible/simple?

    dhrider
    Member

    Not 100% sure but you more than likely need to use an IF formula and have it total in separate cells.

    One for all of A (if A add and total in this cell)
    One for all of B(if B add and total in this cell)
    One for all of C (if C add and total in this cell)

    Premier Icon nickjb
    Subscriber

    Think I’ve got it now. I’m using sumproduct, seems to work

    =SUMPRODUCT(A1:A6=”A”;B1:B6)
    =SUMPRODUCT(A1:A6=”B”;B1:B6)
    =SUMPRODUCT(A1:A6=”C”;B1:B6)

Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘open office calc help’ is closed to new replies.