[Solved] Calculating different budget categories

[Hagar Delest]

Hello everyone. I have started using calc to keep track of my spending. [image blow] is it possible to specify to calc to add all of the same categories (grocery/gas/etc) of expenses into a single cell when it is in this format?

[FJCC]

Your image did not load but I will try to point you in the right direction. Let's say your categories are in column B, rows 2 - 100 and the amounts spent are in column C.

Code: Select all   Expand viewCollapse view

=SUMIF(B2:B100; "gas", C2:C100)

will tell you how much you spent on gas.
If you need more help, please upload a file, not an image.

[Villeroy]

viewtopic.php?t=97746&p=468896#p468896

[nothreat33]

Thank you for the response. I tried it but it didn't seem to work.

[RusselB]

Change the , after "grocery" to a ;

[nothreat33]

Thank you!!