Countif with multi Range

[KIM Chanthan]

Hi,

Anyone have simple way to apply countif with multiple range?

Thanks,
Chanthan

 

[Nebu]

Hi:

If you have cells to be counted is always coloured you can use GET.Cell function to identify the colour and use count if.

Thanks

 

[KIM Chanthan]

Hi:

If you have cells to be counted is always coloured you can use GET.Cell function to identify the colour and use count if.

Thanks

Thanks Nebu, but it doesn't have color actually. I just color in order to identify the cell to be counted.

 

[bosco_yip]

Try,

In N3, enter formula :

=SUMPRODUCT(0+(N(OFFSET(A3,0,{0,2,5,7,9,11}))>0))

Regards
Bosco

 

[GraH - Guido]

Given the data structure this might also work
[N3]=COUNTIFS($A$2:$L$2,"<>"&"",$A$3:$L$3,">"&0)

 

[Peter Bartholomew]

Same solution as Guido!

= COUNTIFS( Header, "<>", Values, ">0" )

Seems that my only contribution is that ">"&0 can be reduced to ">0"