Summation of Categories.

Hello and pre-thanks for any help.

I'm using google docs spreadsheet to track my expenses and I'm also trying to use a pie chart to make things more visible. Let's say I have this going on:

Type Cost
Breakfast $10
Lunch $20
Breakfast $5
Dinner $6
Dinner $7
Lunch $8

I want to group the expenses in a separate column so I can see how much "Breakfast", "Lunch" and "Dinner" are. I tried: "SUMIF(A1:A50, "Breakfast", "B1:B50") but that only includes the Breakfast on the first row. How can I include ALL breakfast?

Thanks again.

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by Greg M

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg,

Thanks for your reply.

I tried that and the same issue still comes up. It only recognizes the first "Breakfast" while the other "Breakfast" in the other rows don't add to the tally of "Breakfast."

Hmm seems like it works if I just click the actual cell and it sorts it all out. Thanks for the help!

Hi again,

The attached workbook contains the value "Breakfast" in Cells A1:A50, and the value 1 in Cells B1:B50.

The formula:

Please Login or Register  to view this content.

is entered in Cell C1 and returns a value of 50.

Does copying your values into the attached workbook help at all?

Regards,

Greg M


P. S. Regarding your last post - is Calculation set to Manual instead of Automatic?

Looks like everything works. Thanks to you both. It was probably because I had some underscores or something.

PS Greg. Not sure what you mean by "manual" or automatic.

Hi again,

Many thanks for your feedback - glad I was able to help.

See Tony's reply to your question about Manual or Automatic Calculation.

Best regards,

Greg M