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

Occasional Visitor

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

1 Reply

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