LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 107
Default Sum Function not working right

I have a column of 722 numbers and I want to add them but when I click the
sum function and select all the cells it returns with a 0. I have made sure
they are numbers, have tried to copy and paste to a different worksheet but
it is all coming out the same. I've even tried to do it with just a couple
numbers in the column and it still says 0.

But, if I type in numbers the sum function works perfectly.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ISBLANK function not working when cell is blank dut to function re mcmilja Excel Discussion (Misc queries) 9 May 7th 23 03:43 AM
IF function not working Loren Excel Discussion (Misc queries) 5 May 5th 08 05:36 PM
Sum function not working, help please! trickdigger Excel Worksheet Functions 2 April 9th 06 03:04 AM
IF(AND function is not working Access Newbie looking for help Excel Worksheet Functions 4 March 20th 06 06:47 PM
Function not working donnaK Excel Worksheet Functions 8 December 8th 05 08:03 PM


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"