PDA

View Full Version : Solved: Error in Sumproduct



asingh
02-04-2008, 05:12 PM
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,

Bob Phillips
02-05-2008, 01:44 AM
Because it returns cell references, not values

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

asingh
02-06-2008, 03:12 AM
Hi,

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

marking as solved...

thanks and regards,

asingh