Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 9th 08, 06:40 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 4
Default =sum doesn't work properly

I'm confused! I've been entering =sum formulas without a problem. Suddenly,
today, all I get is a "0" total instead of the sum of the column. For
instance, =sum(d36:d43) should equal 17, but it shows a 0. The cells are
formatted as "general". What happened?

  #2   Report Post  
Old May 9th 08, 06:54 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 115
Default =sum doesn't work properly

Have you tried formating the cells as numbers?

"Jewels" wrote:

I'm confused! I've been entering =sum formulas without a problem. Suddenly,
today, all I get is a "0" total instead of the sum of the column. For
instance, =sum(d36:d43) should equal 17, but it shows a 0. The cells are
formatted as "general". What happened?

  #3   Report Post  
Old May 9th 08, 07:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default =sum doesn't work properly

On Fri, 9 May 2008 10:40:36 -0700, Jewels
wrote:

I'm confused! I've been entering =sum formulas without a problem. Suddenly,
today, all I get is a "0" total instead of the sum of the column. For
instance, =sum(d36:d43) should equal 17, but it shows a 0. The cells are
formatted as "general". What happened?


Somewhere along the line, the values in the range were entered as or converted
to text. They will retain that attribute until you convert them back to
numbers. How to do this will depend on the contents of the cell, and perhaps
on how this initial conversion took place.

You can always change them back by re-entering them.

If they are the result of a formula, ensure your formula is not returning a
TEXT result.

You might be able to select a blank cell, then
Edit/Copy
then select d36:d43
Edit/Paste Special Add

--ron


Reply
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
Why does this filter not work properly cj21 Excel Discussion (Misc queries) 6 March 29th 06 09:26 PM
function does not work properly lukiedukie Excel Worksheet Functions 3 April 22nd 05 10:23 PM
Can't get code to work properly. Please Help! sparky3883[_8_] Excel Programming 2 April 15th 04 01:55 PM
RefEdit doesn't work properly daMike Excel Programming 3 December 10th 03 02:43 PM


All times are GMT +1. The time now is 05:25 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017