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,