Share via

problems with #VALUE! errors when there is text in a cell being added

Al LePage 20 Reputation points
2025-10-02T15:48:43.7566667+00:00

See description of problem in PDF below

Problem with VALUE error in Excel.pdf

Microsoft 365 and Office | Excel | For home | Windows

Answer accepted by question author

Barry Schwarz 5,756 Reputation points
2025-10-02T16:55:51.2933333+00:00

The + operator does not automatically convert non-numerics to 0. The SUM funciton does. Change your formula in G7 from SUM(+J5+M5+...) to SUMJ(J5,M5,...). Change the formula in G5 from an addition expression to a similar use of the SUM function.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.