COUNTIF function help

[Elemental]

I have used the COUNTIF function before and it works great when doing an in
order cell count (ex. A1:A20). But now I am needing the COUNTIF function
to count certain cell blocks (ex. A1:A3 then A5:A8, etc). How would I go
about doing the formula for this?

My current forumal looks like this and it tells me too many arguments are
entered for this function:

=COUNTIF(D1315,D2123,"=0")

Any help? TIA!

 

[KL]

Hi Elemental,

You can't use COUNTIF with multiple ranges (it only allows two arguments),
so you'll need to do it like this:

=COUNTIF(D1315,"=0")+COUNTIF(D2123,"=0")

or a much less efficient:

=SUMPRODUCT(COUNTIF(INDIRECT({"D1315","D2123"}),"=0"))

Regards,
KL

 

[Elemental]

Thanks for the help! I used you much less efficient method because it was
easier for me to compile all the ranges needed, which were quite a lot! So
again, thanks!