Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |