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

  • Thread starter Thread starter Jontie
  • Start date Start date
J

Jontie

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
 
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
 
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





- Show quoted text -
Click to expand...


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