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: 208
Default SUM command not working

I've used the SUM command for all my life. So I know how to input the
syntax. I recieved a file from another person and I'm trying to add some
math. 2 things happen...

1) Enter sum cells A1:A3 and it doesn't add. Just puts a zero in the cell.
2) Enter sum cells d1:d3 and the text "=sum(d1:d3)" is a fixed in the cell.

How do I correct these oddities??
 
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
Tracking Date/Actual Working Time Elapsed Jive Excel Worksheet Functions 1 September 25th 06 02:14 PM
Highlighted Reference Cell for a Working Cell Mr. Low Excel Worksheet Functions 0 June 22nd 06 04:27 PM
Sumproduct suddenly not working Andy Excel Discussion (Misc queries) 7 July 11th 05 10:56 PM
Calling another workbook not working malik641 Excel Worksheet Functions 2 June 24th 05 07:36 PM
how do I adjust working calendar (6 day work week) in excel that . Hatem Excel Worksheet Functions 1 January 25th 05 12:04 PM


All times are GMT +1. The time now is 11:56 PM.

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

About Us

"It's about Microsoft Excel"