Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SUM Blank Cells in Formula
- Thread starter kmkland
- Start date
SimonDavis
Technical User
Somethings up there . . . Excel is normally quite happy to have empty cells in a range.
Either;
- You're perhaps using autosum, which is only going to the first empty cell? Check the formula covers the whole range. It should look like =sum(a1:a22) if it says =sum(a1) or something, it might be a problem.
- Are you entering numbers as text? If a cell is formatted as text, excel won't recognise it as a number.
Either;
- You're perhaps using autosum, which is only going to the first empty cell? Check the formula covers the whole range. It should look like =sum(a1:a22) if it says =sum(a1) or something, it might be a problem.
- Are you entering numbers as text? If a cell is formatted as text, excel won't recognise it as a number.
- Status
Similar threads
- Locked
- Question
- Locked
- Question