I have created named range in from other workbook.
When I use it in Counta(ccc) it gives correct answer.

However if I use in the sumproduct formula, I get #NA error.
The formula is =SUMPRODUCT(-(ccc=A6)*-(rrr<""))
(I want count of non blank cells in rrr range where range ccc has a
value equall to A6)

I suspect that something is wrong with formula.

Pl help urgently.

Regards,
Madiya