looking up and summing from a table with conditions

[insertusername]

OK, so I have a large table of numbers and text, including formulas. I want to be able to find a formula that looks in the table for all of the entries that have Category X, and return the sum of their corresponding numbers.

I've attached an example file of what I mean.

(I'm new to this forum, go easy on me if I did something wrong!)

[VBA Noob]

Try

=SUMIF($B$2:$B$4,A7,$C$2:$C$4)

VBA Noob

[insertusername]

Ah, that did it. I didn't quite know that's how SUMIF works obviously... to say the least, he he...

Thanks a lot!

[VBA Noob]

No problem

Glad it helped

VBA Noob