SUMPRODUCT Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am using named ranges from the other workbook but I am getting #N/A
error.
My formula is as below.
=SUMPRODUCT((ccc=A6),(rrr<>""))
=SUMPRODUCT(-(ccc=A6),-(rrr<>""))

When I use counta with ccc or rrr, I am getting correct answer.
But now I want the count of non blank rrr where ccc value equals value
of A6.

Please help me to sort out this error.

Regards,
Madiya

.

Quantcast