Formula - only SUM based on criteria

[Jer-XL-emy]

Hi all ex(cel)perts,

I am looking for a formula that would sum all cells that meet a specific criterion in a different cell.

To Illustrate:

I have NAMES of individuals in column C and TOTALs in columns E. I am hoping there is a way were XL automatically finds the name and the appropriate total of the name (where name is in column C and total in column E) and it will sum the total at the bottom of the page - so at the bottom of the page I would have all the list of names each containing the formula that would sum the total of all numbers associated with that name.

I hope I am being clear.

Thank you in advance

 

[Norie]

Perhaps the inbuilt functionality Data>Pivot table report...?

 

[VoG]

Try SUMIF

=SUMIF(C:C,"Fred",E:E)

 

[Jer-XL-emy]

Thank you very much VoG II - that works great and much smaller than I though it was goingg to be