=countif(with two set of ranges; "0")
 

This is my formula =COUNTIF(E11:E18;"0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do. thanks
in advance for your help

=countif(with two set of ranges; "0")
 

Hi,

Note i've changed ; to , for my version of Excel so change it back for yours:-

=COUNTIF(E11:E18,"0")+COUNTIF(E23:E50,"0")

Mike

"Jontie" wrote:

This is my formula =COUNTIF(E11:E18;"0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do. thanks
in advance for your help

=countif(with two set of ranges; "0")
 

On Dec 16, 4:36 am, Mike H wrote:
Hi,

Note i've changed ; to , for my version of Excel so change it back for yours:-

=COUNTIF(E11:E18,"0")+COUNTIF(E23:E50,"0")

Mike



"Jontie" wrote:
This is my formula =COUNTIF(E11:E18;"0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do. thanks
in advance for your help- Hide quoted text -

- Show quoted text -


yea that bothers me alot as I am using opensource thanks for you help
it worked for me happy holidays