Question description:
This user has given permission to use the problem statement for this
blog.
i NEED TO SUMM UP TO ONE THOUSAND ENTRIES IN A COLUMN
Solved by T. W. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/04/2018 - 03:09
Hi…Welcome to Got It Pro
Excelchat Expert
13/04/2018 - 03:09
You can use SUM function to sum up all the entries.
Excelchat Expert
13/04/2018 - 03:10
Say your data is in column A from A1 through A1000, then your formula should be =SUM(A1:A1000)
User
13/04/2018 - 03:10
Hi, I have a spreadsheet of my expenses and it now has 500 line. It will have up to 1000. How can I summ a column this long? at the momnet the autosum only works to about 450 line.
Excelchat Expert
13/04/2018 - 03:10
Does that answer your query?
Excelchat Expert
13/04/2018 - 03:10
could you share the file?
User
13/04/2018 - 03:11
this does not seem to work
Excelchat Expert
13/04/2018 - 03:12
Please share your data or you can replicate the same in this blank sheet so that I can help you.
User
13/04/2018 - 03:19
here's part of the s/s
Excelchat Expert
13/04/2018 - 03:20
ok...where should the sum be?
User
13/04/2018 - 03:20
at bottom or top or anywhere
User
13/04/2018 - 03:21
lets say at the bottom of each column
Excelchat Expert
13/04/2018 - 03:21
and your sum should be starting from which row?
User
13/04/2018 - 03:22
top row to row 1000
Excelchat Expert
13/04/2018 - 03:23
ok...you will not get the sum results, because you have entered the amounts as text
Excelchat Expert
13/04/2018 - 03:23
you will have to enter only number and format them as currency for the sum to work.
Excelchat Expert
13/04/2018 - 03:24
Sum would require your amount to be numeric and not text
Excelchat Expert
13/04/2018 - 03:24
So please remove all currency symbols
Excelchat Expert
13/04/2018 - 03:24
and you can later format the cells as currency
Excelchat Expert
13/04/2018 - 03:26
I have done all these cleansing in this sheet and now you can see the totals in row 1001 (the last row)
Excelchat Expert
13/04/2018 - 03:26
Does that solve your query?
User
13/04/2018 - 03:27
thanks for your help I will try that
Excelchat Expert
13/04/2018 - 03:27
sure please do
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.