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,