The total of a couple cells and only include one of the cells if >

Discussion in 'Microsoft Excel Misc' started by Guest, Apr 17, 2007.

  1. Guest

    Guest Guest

    I'm hoping someone out there can help me with an Excel question.

    What I want to do is have the currency total of a couple cells and only
    include one of the cells if that cell is greater than zero. This is the
    formula I came up with but unfortunatley, it doesn't work.

    =((IF(N43>0,N43,"")(N44:N48)))

    Can someone help me!
     
    Guest, Apr 17, 2007
    #1
    1. Advertisements

  2. =IF(N43>0,N43,0)+SUM(N44:N48)

    Regards

    Trevor
     
    Trevor Shuttleworth, Apr 17, 2007
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    =SUM(IF(N43>0,N44:N48))

    ctrl+shift+enter, not just enter
     
    Guest, Apr 17, 2007
    #3
  4. You talked of "a couple cells". "A couple" usually means 2, so if you are
    trying to add the 2 cells N44 and N48, the formula is =N44+N48.
    If you use =SUM(N44:N48) it will add all 4 cells in that range. If you want
    to add another value if it is greater than zero, you can use MAX(N43,0),
    hence you may want a formula like =SUM(N44:N48)+MAX(N43,0)
     
    David Biddulph, Apr 18, 2007
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.