Countif multiple ranges, same criteria

**ebaldwin** · 05-14-2012, 09:54 AM

Please help, I know I am missing something simple in building the formula, but I need to add in two additional ranges in the formula below:

=COUNTIF(H6:H21,">0")

I have unsuccessfully tried a variety of tweaks to the formula to get the result I need. A smattering are below for your viewing pleasure:

=COUNTIF((H6:H21,H23,H33:H36),">0")

=COUNTIF((H6:H21)+(H23)+(H33:H36),">0")

=COUNTIF((H6:H21):(H23):(H33:H36),">0")

I'm sure there is an easy solution available, and I just don't know enough about the proper formula structure to find it, but I am still learning. I would appreciate any help offered!

Thanks!

**jeffreybrown** · 05-14-2012, 09:58 AM

Does this do what you need?

=COUNTIF(H6:H21,H23)+COUNTIF(H33:H36,">0")

**ebaldwin** · 05-14-2012, 10:18 AM

It did not, but this did:

=COUNTIF(H6:H21,">0")+COUNTIF(H23,">0")+COUNTIF(H33:H36,">0")

I can't believe with all of the other things I tried, that I did not try this solution... I probably did, and just put in a bunch of extra parenthesis. Sheesh...

Thank you so much!!