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