Formula - only SUM based on criteria

Jer-XL-emy

Board Regular
Joined
Aug 27, 2007
Messages
60
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
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,559
Office Version
365
Platform
Windows
Perhaps the inbuilt functionality Data>Pivot table report...?
 

Jer-XL-emy

Board Regular
Joined
Aug 27, 2007
Messages
60
Thank you very much VoG II - that works great and much smaller than I though it was goingg to be
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,818
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top