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

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

--

HTH

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


"Stacy M via OfficeKB.com" wrote in message
...

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

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" wrote:


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

Thank you so much!! This worked great!

bj wrote:
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!!