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

  • Thread starter Thread starter Trishalu
  • Start date Start date
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
 
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

using SUM to add up only some numbers in a column 7
Sum the last 5 numbers in a column 6
Adding variable number of columns 8
Time Sum in Excel 1
Last number in a column shows in the total/summay line cell 3
Sum the last 21 cells 17
summing last values in column 11
Last Modified By in a cell by user 3

Back
Top