**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.*