Here it is...
G11 corresponds to the sheet I want the cells to pull info off of...
M8 =INDIRECT(G11& "!BD23")
N8 =INDIRECT(G11& "!BD52")
O8 (oh8) =IF(ISERROR(N8+M8), "0", N8+M8)
If M8 = 5, N8 = 3, then O8 = 8
The problem is if either M8 or N8 is blank because the referenced cell is blank, O8 remains 0. Any may to make M8 and N8 show 0 if the referenced cell is blank or make O8 automatically calculate a blank in M8 or N8 as 0? This is complicated..All help would be appreciated.
G11 corresponds to the sheet I want the cells to pull info off of...
M8 =INDIRECT(G11& "!BD23")
N8 =INDIRECT(G11& "!BD52")
O8 (oh8) =IF(ISERROR(N8+M8), "0", N8+M8)
If M8 = 5, N8 = 3, then O8 = 8
The problem is if either M8 or N8 is blank because the referenced cell is blank, O8 remains 0. Any may to make M8 and N8 show 0 if the referenced cell is blank or make O8 automatically calculate a blank in M8 or N8 as 0? This is complicated..All help would be appreciated.