CountIfs VBA

[cmccabe]

I am having trouble converting a SUMPRODUCT formula into a COUNTIFS. The line of code below contains the correct ranges.

Please Login or Register  to view this content.

Here is the original COUNTIFS formula:

Please Login or Register  to view this content.

My attempt errors on the underlined line. (object defined or application defined error)
VB

Please Login or Register  to view this content.

Thank you.

[Norie]

Why can't you use the original COUNTIFS formula?

Please Login or Register  to view this content.

[cmccabe]

All the values are no longer on one sheet.

VB

Please Login or Register  to view this content.

? Thanks.

[cmccabe]

When I use that code instead, I get an objecy or application defined error on the underlined line. Thanks.

VB

Please Login or Register  to view this content.

[Norie]

I meant to say that you should change any sheet/range references if required.

Anyway, this will not cause an error.

Please Login or Register  to view this content.

[cmccabe]

It is not the formula line that throws an error it is this line: Thanks.

Please Login or Register  to view this content.

[Norie]

The reason forthe error on that line of code is the formula being incorrect.

[cmccabe]

Thank you Norie , it is working now. I has an extra space and a $ in the formula.