How to sum a column by category

[JayFromBoston]

What code can i put into the two cells highlighted in yellow to sum up the WDRAW column by category? See attached image. I'M TRYING TO FIGURE OUT WHERE MY MONEY IS GOING!

 

[Fluff]

Hi & welcome to MrExcel.
Have a look at SUMIF function
https://exceljet.net/excel-functions/excel-sumif-function

 

[AlanY]

=SUMIF(E:E,"health",C:C)

similar for the other

 

[JayFromBoston]

THANKS SO MUCH! How would the code look different if the sum were on a separate tab? =SUMIF(Tab1:E:E,"health",Tab1:C:C)

???

 

[JayFromBoston]

I figured it out thanks!

 

[My Aswer Is This]

You can use this also:
=SUMIF(E:E,G7,C:C)

Put the value you want the sum of like Cake
Into Range("G7")