Auto sum only adding the last few numbers in the column.

T

Trishalu

I select the column of numbers. Some cells have no value because no charge
has been posted to that line item. I need to know the totals as the month
progresses. But when I select cells from the top of the list (client A) to
the bottom of the list (client z), autosum only adds together the last few
numbers selected. What am I doing wrong. I've done this before and I've
gotten totals, even when some cells had nothing posted to them.
Thanks, Trishalu
 
T

T. Valko

Some cells may contain TEXT numbers. Are these numbers the result of a
formula or are they manually entered?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Sum not working correctly 1
An Odd problem with SUM using : 0
Auto Sum range with multiple columns. 1
using SUM to add up only some numbers in a column 7
Adding variable number of columns 8
Sum the last 5 numbers in a column 6
formula issues. 0
adding multiple values from matched search results 3

Top