Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
How do i protect a work sheet in excel 2000 that will still enabl. | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |