Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 08, 08:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 11
Default A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00),

I AM USING THE SUM FUNCTION OF EXCEL 2003, IT RETURNS A ZERO VALUE WHEN
SUMMING A COLUMN OF FIGURES WHICH ARE NOT RESULTING FROM A FORMULA. IT
DISPLAYS (0.00) INSTEAD OF 0.00. WOULD YOU PLEASE HELP ME REMOVE THE BRACKETS
FROM A ZERO VALUE ? THANKS

  #2   Report Post  
Old April 28th 08, 08:48 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,594
Default A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00),

Sounds like text instead of numbers.

See if this returns a result

=SUMPRODUCT(--(A1:A20))

If so, it is text, and should be corrected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"eva cheng" wrote in message
...
I AM USING THE SUM FUNCTION OF EXCEL 2003, IT RETURNS A ZERO VALUE WHEN
SUMMING A COLUMN OF FIGURES WHICH ARE NOT RESULTING FROM A FORMULA. IT
DISPLAYS (0.00) INSTEAD OF 0.00. WOULD YOU PLEASE HELP ME REMOVE THE
BRACKETS
FROM A ZERO VALUE ? THANKS



  #3   Report Post  
Old April 28th 08, 08:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00),

Perhaps the value is really <0

..00000099999 could give you a reading of (0.00) if formatted for negative
number.

Extend the decimal points out a ways to see what the value is.


Gord Dibben MS Excel MVP

On Mon, 28 Apr 2008 00:33:03 -0700, eva cheng
wrote:

I AM USING THE SUM FUNCTION OF EXCEL 2003, IT RETURNS A ZERO VALUE WHEN
SUMMING A COLUMN OF FIGURES WHICH ARE NOT RESULTING FROM A FORMULA. IT
DISPLAYS (0.00) INSTEAD OF 0.00. WOULD YOU PLEASE HELP ME REMOVE THE BRACKETS
FROM A ZERO VALUE ? THANKS




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
RTD Function Always Returns #N/A in Excel 2007 Jose Excel Worksheet Functions 0 November 29th 06 08:29 PM
RTD Function Always Returns #N/A in Excel 2007 Jose Excel Worksheet Functions 0 November 29th 06 08:28 PM
Excel function LARGE returns error 'too few arguments' Browndoff Excel Worksheet Functions 5 July 26th 06 09:55 PM
Excel "mode" function returns different results based on sort orde Mark Neuffer Excel Worksheet Functions 7 April 25th 06 08:15 AM
Why sometimes excel returns error just because function parameters are linked? Paul134 Excel Worksheet Functions 2 February 28th 06 06:15 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017