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

G

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!
 
D

David Biddulph

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)
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing cells defined as Time hh:mm 4
Displaying zeros in cells 2
Errors in Excel 2007 Calculation 3
Question about conditional formatting of zeros in Excel 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to do - B2 is only valid if B1 is zero 1
Count only visible cells 4
Another Formula Question 3

Top