=COUNTIF([range],"Eric") -- replace [range] with the correct range on your
worksheet.

=SUMIF([range],"Eric") -- replace [range] with the correct range on your
worksheet.
--
Brevity is the soul of wit.


"tom ossieur" wrote:

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