Sum values if left column has certain word criteria

Hi All,

I have the following table:

Category Value
Rent £650
Misc £99
Sister £200
Rent £650
Sister £20


I want to create seperate sums for all of these categories, but how do i write a sum formula so that it checks the category before adding a cell value to the total?

Thank you.

Best,
Andy

Just discovered SUMIF() Thank you anyway.

Hi,

If Category is in column A, Value in column B and in D1 is say Rent, then use this formula:

=SUMIF($A$1:$A$5,D$1,$B$1:$B$5)