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: 577
Default 'SUM' isn't working - what would cause this ?

This is a little strange. I have exported data from one of our applications
into Excel. I'm trying to total a range of numbers but it's just giving me
'0'.

I've formated the number cells to be 'numbers' and I've made sure the cell
i'm putting the 'SUM' formula in is formatted as 'general'. but it's still
not working. Anyone know what else I could try ? There has to be something
simple I'm overlooking. Thank in advance !
 
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
Calculate working days but change working week SamB Excel Discussion (Misc queries) 1 September 1st 08 09:17 PM
Making weekend days working days - the system cuts the working tim Fluffy Excel Discussion (Misc queries) 1 May 30th 08 10:02 PM
How do I 'SUM' a column corrected to 2 decimal places from 3 barkingmad Excel Discussion (Misc queries) 2 May 19th 08 10:01 AM
how to put 'SUM' formula in VB after picking up certain names and their bonus [email protected] Excel Discussion (Misc queries) 11 January 31st 07 10:19 AM
'SUM' Tables masster Excel Worksheet Functions 4 August 27th 05 07:33 AM


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