Okay, thanks Gordon. Is there an easier way to make this formula work?
Maybe I'm doing something wrong???
--
Regards,
Sarah


"Gordon" wrote:

"Sarah" wrote in message
...
Hello,
I have a spreadsheet set up with column A for the date (one day per row),
and column D as the total daily takings. I want a formula that changes
automatically when I enter each new daily amount, and if I enter a daily
taking of $0, I don't want excel to include that day in the month's
average.

If you don't include days of zero takings in the average then your average
will be wrong and misleading.

Gordon Burgess-Parker
Systems and Management Accountant