Maths numpty

[gus3049]

Hello,

I do our monthly books with Exell and, at present, do a few things manually that I'm sure could be done automatically. What I need is a total for each heading such as 'food', 'misc' etc. I want to find those words in one column and then add the values in another that the words relate to. Each total should appear in one cell so I know the monthly expenditure. So lookup all 'foods' and add the sums the word refers to.
Does that make sense? I don't want to change the layout as I've got used to it. Hopefully I can load a pic of how I've laid it out.

 

[Fluff]

Hi & welcome to MrExcel.
Do you mean you want to sum col A where col B says food?

 

[gus3049]

Hi & welcome to MrExcel.
Do you mean you want to sum col A where col B says food?

That does sound like what I want to do Or in this case column C!!

 

[Fluff]

Ok, how about

=SUMIFS(A:A,C:C,"food")

 

[gus3049]

You are a star and obviously a genius. Thanks.

 

[Fluff]

You're welcome & thanks for the feedback.