Simple sum of a range of cells not working but will work with individual cell values.

[Timbo66]

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 now driving me mad!

Any help much appreciated

thanks

[#2]

@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.