Hi Madiya,

Your formula works fine for me (the "-" signs are not necessary). If the
named ranges are in another workbook they need to be prefixed with
Bookname.xls!, possibly bracketed with apostrophes.

In the input bar, select ccc=A6 and rrr<"". You should see a series of
{True, False, ...}. Press Esc to reset the formula.

Regards,
Peter T

"Madiya" wrote in message
oups.com...
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