Forum Discussion

Timbo66's avatar
Timbo66
Copper Contributor
Nov 18, 2022

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

 

Any help much appreciated

 

thanks

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 18, 2022

    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.

Resources