LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ros M
 
Posts: n/a
Default Can't get SUM function to work in Excel 2000

I don't know what I'm doing wrong. All I'm trying to do is add a column of
numbers. In cell L13, my formula is =SUM(L2:L12). All I get back is 0. I've
checked the formatting of the cells and they are all numeric. I have also
tried adding cells manually, e.g., =L2+L3 -- and I get the correct result.
I'm pretty sure I've used this function before without any problems. What am
I doing wrong?

I was having a little problem with setting the formatting. Most of my
spreadsheet contains wrappable text, and I had set the style for that. Then
when I tried to adjust my numeric columns, it kept applying the numeric
format to the entire worksheet until I figured out how to specify a separate
style for those columns. Could I have messed something up there?
 
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
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
How do i protect a work sheet in excel 2000 that will still enabl. Paul Excel Discussion (Misc queries) 2 April 13th 05 12:59 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 07:22 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"