MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
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?
Posted : 29/12/2012 7:15 pm
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)
Posted : 29/12/2012 7:19 pm
Topic starter
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)
Posted : 29/12/2012 7:46 pm