Thread
:
COUNTIF or something else?
View Single Post
#
10
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
COUNTIF or something else?
try this idea
=SUMPRODUCT((G2:G22=1)*(H2:z22="yes"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Count-Adi" wrote in message
...
I am trying to use COUNTIF function where the range might vary. For
instance,
I want to know how many yes I have in column D and E together, with the
condition that C will be only equal with 1.
C D E
1
1 Yes
1 Yes
1
2 Yes
2
2 Yes
3 Yes
3 Yes
3 Yes
3
{=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes€¯)} should be 2.
Thanks for your help.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett