Possible IF statement?

[Stacy M via OfficeKB.com]

Hello,

I am trying to make an accounts payable spreadsheet based on patient visits
our doctors perform. Is there any way to build a formula that, if you put a
date in a cell, it will add up what is due in a total column? I thought using
an IF statement would work, but I'm not sure what the IF part would be.
Basically, I need a formula that if something is entered in a cell, it will
calculate an amount due for that cell and add a sum total at the end. It's
set up something like this:

Visit 1 Visit 2 Visit 3 Total
Amount Due
$300 $275 $150

1/4/05 2/5/05

To clarify, I need something in the amount due column to automatically figure
that $575 is presently due because there are dates entered.

I hope this makes sense!! If anybody has any idea or resources that I could
follow up with, I'd greatly appreciate it!!

 

[Bob Phillips]

=sumif(3:3,">0",2:2)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[bj]

try something like
=sumproduct(--(visit range<>0),Cost range)
in your totals column.
note the Visit range and Cost range must be the same size
the --( converts the true false logical statement to a 1,0 numeric value.

 

[Stacy M via OfficeKB.com]

Thank you so much!! This worked great!

try something like
=sumproduct(--(visit range<>0),Cost range)
in your totals column.
note the Visit range and Cost range must be the same size
the --( converts the true false logical statement to a 1,0 numeric value.

Hello,

[quoted text clipped - 17 lines]

I hope this makes sense!! If anybody has any idea or resources that I could
follow up with, I'd greatly appreciate it!!