|
COUNTIF FUNCTION
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 |
=SUMIF(B:B,"David",E:E)
etc. -- HTH Bob Phillips "David Harrison" wrote in message ... 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 |
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. -- Regards Robert Find me at www.juliobattisti.com.br/forum/default.asp |
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: 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 |
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. -- Vasant "David Harrison" wrote in message ... 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 |
| All times are GMT +1. The time now is 10:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com