Excel 2007 SP2+
I am getting a #REF error on this:
=IF(D$1+1<=ROW(),SUM(INDIRECT("RawData!F" & ROW()-D$1+1&":RawData!F" &
I have tried several ideas... none of them work to resolve the #REF errors.
SOME ideas I have tried: Format to be General, Format to be Number (0 decimal
places), Format to be Text for the D$1 cell. The format on the RawData!
cells are numeric.
In stepping through the calculations, everything appears to work fine except
for the final calculation on
performed I receive the #REF error message. I receive
IF(TRUE,(SUM(#REF!),""). So, the issue is evidently relating to the RawData
cells and/or the format of the cell types or ????.
ANY assistance would be appreciated. The format for the cells to store the
SUM calculated values are numeric.
I am totally lost! ;-(