SUM for Category
Hi,
I'm trying to get a formula to calculate the total cost for each category type into a new table.
Let me know if you can help on that one!
Thanks,
Justin
iMac (27-inch Mid 2011), iOS 7.1
Question marked as
Best reply
You could try something like this:
The formula in B2 of the Summary table, copied down, is:
=SUMIF(Data::C,A2,Data::B)
This says sum numbers in column B of Data where the value in column C of Data matches cell A2 of Summary.
(Replace , with . and ; as necessary for your localization.)
SG