Solved: Error in Sumproduct

Hi,

Please could someone tell, why the first sumproduct is not working, and the second one is..so is the third one...!

When evaluating for a numerical using INDIRECT(ADDRESS(ROW(),column#)) I get an error. Same thing happens..when I try this in array functions.

Attached is the sheet.

thanks and regards,

Because it returns cell references, not values

=SUMPRODUCT(--(N(INDIRECT(ADDRESS(ROW(),2)))=$H$5:$H$17))

Hi,

thanks XLD..works perfect with the N operator.....

marking as solved...

thanks and regards,

asingh