Re: count entries

=SUMPRODUCT((A2:A18="john")*B2:C18)

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"tom ossieur" <tomossieur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:354055F8-14BC-452D-9FB5-FC244AA0BCBB@xxxxxxxxxxxxxxxx
Hi! Thanks for the answers!

still encountering problems with SUMIF. The actual table contains sevrel
colums with data.

an example:

A B C
1 green red
2 John 4 2
3 Fred 1 3
4 Eric 111 1
5 Eric 5 3
6 John 5 4
7 Eric 5 2
8 Fred 5 2
9 Eric 5 1



=SUMIF(A2:C9,"John")

The result is 0, how to get 2+4=6 as a result?

Thanks a lot!

tom


"Dave F" wrote:

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

=SUMIF([range],"Eric") --> replace [range] with the correct range on your
work***.
--
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


.