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,
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,