Thread
:
count entries
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
count entries
look in the help index for COUNTIF and SUMIF
--
Don Guillett
SalesAid Software
"tom ossieur" wrote in message
...
Hi!
given the table below - example -
John 2
Fred 3
Eric 1
Eric 3
John 4
Eric 2
Fred 2
Eric 1
1. I want to count how often a name occurs
e.g. Eric = 4
2. I want to calculate the sum of the values for a certain person
e.g. Eric = 7
Any solution?
Thanks!
tom
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett