COUNTIF FUNCTION

D

David Harrison

OK HERE WE GO AGAIN!!

I have a Validation List with about 20 different names in it.

In the list the name maybe displayed more than once. After each name there
is a total.

So Say

David £5.00
Richard £7.00
Ben £15.00
Gary £100.0
David £75.00
David £5.00
Richard £21.50
Ben £56.84

What i need to do is a do a sumary at the bottom of the work sheet. I have
put the whole list at the bottom and need to put a function in the total
amount for each person.

E.g.David - £85.00
Richard £28.50
Ben £71.84

What is the function. Say the name is colum B and the amount is colum E

Cheers

David
 
C

cmart02

David,

Select the area go to Data --> PivotTable. Once you're done with the Wizard,
drop the names on the Row Fields area and the value in the Data Items area.

This will summarize the data the way you want.
 
N

NilsIvar

Hello David!

How about using SUMIF:

=SUMIF(B1:B8;B14;E1:E8)

where B1:B8 is your name list,
B14 is "David", and
E1:E8 is your value list.


David Harrison skrev:
 
V

Vasant Nanavati

If your list is in A1:B20 and your summary starts in A30, enter in B30 and
copy down:

=SUMIF(A$1:A$20,A30,B$1:B$20)

where A30 and the cells below contain the names.
 
Top