Results 1 to 3 of 3

Thread: SUM Formula returning value as 'zero'

  1. #1

    SUM Formula returning value as 'zero'

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Could someone help please. When I use the SUM formula of a group of cells containing other formulas, it returns as a zero value.

    I have attached an example and the problem lies in cell D30.

    Any help would be much appreciated.
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    FIXED creates a text string, SUM works on numbers.

    Get rid of the FIXED and concatenating " m" in the formula and use a custom of format of #,##0.00 " m" and then the SUM will work.

  3. #3
    Scratch ..... didn't notice Bob had already posted an answer.
    Last edited by tommyt61; 2012-08-23 at 03:36 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts