COUNTIF or something else?
In this way it counts for all cells( from B2 to C11), but I am interested
only for those whit 1 in column A. Thanks
"Atif" wrote:
{=IF(A2:A12=1,COUNTIF(B2:C11,"Yes"),0)}
This should work
Atif
"Count-Adi" wrote:
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.
|