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

Top