Results 1 to 6 of 6

Thread: Sum Function

  1. #1

    Angry Sum Function



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

    The sum function will not calculate the sum of a range of cells containing numbers resulting from a range of IF functions. How can I correct this?? Ihave tried all the recommended soluyion to no avail.


    Q1 4 0 0 0 0 0 0 0
    Q2 5 1 1 1 1 1 5 1
    Q3 6 1 1 1 1 1 5 1
    Q4 7 1 1 1 1 1 5 1
    Q5 8 1 1 1 1 1 5 1
    Q6 9 1 1 1 1 1 5 1
    25 ?

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,335
    Articles
    0
    Excel Version
    Office 365 Subscription
    What is the formula you are using and where? If the final column, then there is a clue in the fact that the numbers are aligned left: thus suggests that they are text, not numbers.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    I have already checked the cell and they are set on "general" .I have also set them as number with the same result.
    The formula used to calculate the cells in question is =IF(AB46>=1,"1",IF(AB46<1,"0")) AB is the row with the 0.5.5.5.5.5.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,335
    Articles
    0
    Excel Version
    Office 365 Subscription
    See if this makes any difference:

    =IF(AB46>=1,1,IF(AB46<1,0))

    Notice no inverted commas around the numbers.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Quote Originally Posted by AliGW View Post
    See if this makes any difference:

    =IF(AB46>=1,1,IF(AB46<1,0))

    Notice no inverted commas around the numbers.
    This enables the Auto Sum to activate and I have achieved this previously by manually inserting a sum formula. Unfortuanately whilst the formulas say it is adding the relevant cell range containing figures 0.1.1.1.1.1 it is showing a total of 1 not 5.??

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,685
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please post a small sample sheet (click Go advanced - Manage attachments). Thanks

    BTW, please do not quote entire posts unnecessarily. They make the thread hard to follow.
    Shorter version of Ali's formula =--(AB46>=1)
    Last edited by Pecoflyer; 2016-12-19 at 12:13 PM.
    Thank you Ken for this secure forum.

Posting Permissions

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