=INDIRECT("'"&K$4&"'!"& INDIRECT("'"&K$2&"'!"&"R2"&14):INDIRECT("'"&K$2&"'!"&"S2"&14))
Cell k4 contains sheet name 1
Cell K2 contains sheet name 2
Cells r2 and s2 in sheet name 2 contain letters representing column references, for row 14
I can get the two indirect functions to work separately, but when I combine them into the above formula, I get #value!
what is wrong with the formula?
Thanks
System Info Sheet in workbook
Annual Sheet in workbook
Method 1 2950 summing three cells in Annual sheet directly
Method 2 2950 summing those cells in this sheet by way of indirect reference to System Info sheet
Method 3 2950 summing three cells in Annual sheet by way of indirect reference to Annual sheet
832 982 1135
#VALUE! trying to sum those three cells by way of indirect reference to Annual sheet and indirect reference to System Info sheet (combining Methods 2 and 3)
Cell k4 contains sheet name 1
Cell K2 contains sheet name 2
Cells r2 and s2 in sheet name 2 contain letters representing column references, for row 14
I can get the two indirect functions to work separately, but when I combine them into the above formula, I get #value!
what is wrong with the formula?
Thanks
System Info Sheet in workbook
Annual Sheet in workbook
Method 1 2950 summing three cells in Annual sheet directly
Method 2 2950 summing those cells in this sheet by way of indirect reference to System Info sheet
Method 3 2950 summing three cells in Annual sheet by way of indirect reference to Annual sheet
832 982 1135
#VALUE! trying to sum those three cells by way of indirect reference to Annual sheet and indirect reference to System Info sheet (combining Methods 2 and 3)