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

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(N430,N43,"")(N44:N48)))

Can someone help me!

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

=IF(N430,N43,0)+SUM(N44:N48)

Regards

Trevor


"Jennifer" <Jennifer @discussions.microsoft.com wrote in message
...
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(N430,N43,"")(N44:N48)))

Can someone help me!

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

=SUM(IF(N430,N44:N48))

ctrl+shift+enter, not just enter


"Jennifer" wrote:

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.

(N=((IF430,N43,"")(N44:N48)))

Can someone help me!

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

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

"Jennifer" <Jennifer @discussions.microsoft.com wrote in message
...
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(N430,N43,"")(N44:N48)))

Can someone help me!