count if question

[gurmy77]

I am trying to help out the office at work with this one but I seem to be
missing something. First off they are using excel 2003. I know the first
answer is pivot table but that seems over thier heads.

3 name1 yes
3 name2 no yes
4 name3 no no no
4 name4
5 name5 yes

Ok the numbers in the A column are a referance to what group these are in.
the names in "B" are indifferent and are there just for informational purposes
there are 3 "C" "D" "E" columns in which a "yes" "no" or nothing is entered
I need to referance group "3" and count how many yeses they have and so on
for each group.

I keep getting errors when doing countif statements. Another challenge is
that I haven't used 03 since 07 came out so I am a bit rusty on the functions
of 03. and there are 60+ groups with at least 10 in each group.

 

[Ashish Mathur]

Hi,

Try this. I am assuming that data below is in range A1:E5

SUMPRODUCT((A1:A5=3)*(C1:E5="yes"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[gurmy77]

That was it thank you. I must say in my years of working with 03 in my
accounting classes I never had to use sumproduct. Thank you again.

 

[Ashish Mathur]

Thank you for your feedback

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com