Forum Discussion
Simple sum of a range of cells not working but will work with individual cell values.
I am trying to sum a range of cells but keep getting a returned #VALUE error. If I change the formula to not contain a range the sum will work! All my cells are formatted as number not text and it is...
Timbo66 SUM should not return a #VALUE error unless the range you are summing contains such an error. SUM will ignore texts and not result in an error if your range includes texts.