Adding column of numbers with condition in Excel

[Abbiey]

In Excel 2003 I want to add the total number of surveys conducted per supervisor if my data in excel looks like the following :

Supervisor Employ Survey Total
shane mike A 5
shane mike B 4
chris mike C 2

What i need is to find out the total number of surveys conducted per supervisors. I have tried to use a several type of variations of arrays and vlookups but could not get it. please tell me how can i add column of numbers with condition specified above.

[Sam.D]

The data which you have posted is confusing me a bit can you tell me that what actually you want if possible try to create anpther table like the one you have posted below and then you can create a new column and in that can you please show me what value will you get after applying the formula. This would create a clear picture of your problem.

[Raine]

Hi i agree with sam D 's post above that the table which you have created does not create a clear picture of your problem i woul also require another table please specify the result what you want in a different column so that the problem would be better understood. I would wait till your further post

[ThoMas321]

Let us assume that the names are in column A and totals are in the column B
then the SumIF formula can solve your problem.
Now,
In Column C enter the name of all your personnel one per line,
then in column D enter the formula:
=SUMIF($A$1:$A$40,C1,$B$1:$B$45)

Then just drag it and you will get the result for all your sheet. If this is not what you want then you can post it in your further replies.

[Abbiey]

Thanks for replying me friend but i have not got the solution yet can you please specify what actually you haven't understood. because i have made everything clear in thing clear in my first reply itself. But no matter i will cear it up once again as you can see the above table i would like to shane's survey to be added as 5+4 and chris's should be only 2.