summing specific cells

[the6thplague]

Hi,
I am new to the forum and I have a question about excel.

I have a chart which looks something like this:

A B C
1 200 Joe
2 150 Joe
3 100 Mike
4
5 50 Joe
6 100 Mike
7
8

I want to use a function that will some up all the numbers from colum A that have Joe on on colum B. For example for Joe it should be 200+150+50. And for Mike it should be 100+100. I want to display that sum for Joe in C1 and for Mike in C2. So basically I need a function that will go through colum B and search for the word "Joe" and then if it appears for example in B1 then it will add A1 to the total.

I hope that makes sense and I hope someone can help.

Thanks a lot!
Eyal.

[sweep]

Hi,

Using your example

=SUMIF(B1:B6,"Joe",A1:A6)

Will sum column A where column B = Joe

[the6thplague]

Excellent!

THANK YOU!