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!

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" <elemental~NOSPAM~@mayhemkrew.com> wrote in message
news:wNidnZzd1-pb_L7eRVn-(E-Mail Removed)...
>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!
>

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!


"KL" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <elemental~NOSPAM~@mayhemkrew.com> wrote in message
> news:wNidnZzd1-pb_L7eRVn-(E-Mail Removed)...
>>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!
>>
>
>