Sum Function
 

I have a spreadsheet (very simple) that needs to add all the numbers in a
column and give me the sum. I used the "sum" function and the total comes
out wrong in all three columns and I can't figure out for the life of me why.

When I use the sum feature on the bottom right of the spreadsheet (in the
gray area at the bottom of the screen, the sum is correct, but not where I
put the sum at the bottom of the column.

I'm not sure if anyone can help without actually seeing the spreadsheet.

See if the first topic here helps, BStacy:
http://www.officearticles.com/excel/...soft_excel.htm

If not, you can email the workbook to anne@ either of the websites in my
signature.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"BStacy" wrote in message
...
I have a spreadsheet (very simple) that needs to add all the numbers in a
column and give me the sum. I used the "sum" function and the total comes
out wrong in all three columns and I can't figure out for the life of me
why.

When I use the sum feature on the bottom right of the spreadsheet (in the
gray area at the bottom of the screen, the sum is correct, but not where I
put the sum at the bottom of the column.

I'm not sure if anyone can help without actually seeing the spreadsheet.

please post your equation.

"BStacy" wrote:

I have a spreadsheet (very simple) that needs to add all the numbers in a
column and give me the sum. I used the "sum" function and the total comes
out wrong in all three columns and I can't figure out for the life of me why.

When I use the sum feature on the bottom right of the spreadsheet (in the
gray area at the bottom of the screen, the sum is correct, but not where I
put the sum at the bottom of the column.

I'm not sure if anyone can help without actually seeing the spreadsheet.

Thank you for your response. I found a hidden row in the spreadsheet, which
is what caused the error.

"BStacy" wrote:

I have a spreadsheet (very simple) that needs to add all the numbers in a
column and give me the sum. I used the "sum" function and the total comes
out wrong in all three columns and I can't figure out for the life of me why.

When I use the sum feature on the bottom right of the spreadsheet (in the
gray area at the bottom of the screen, the sum is correct, but not where I
put the sum at the bottom of the column.

I'm not sure if anyone can help without actually seeing the spreadsheet.