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