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

as there are no more than 31 days in any one month, do a SUM of your column
with the takings, in the cell on the 33rd row.....then use that to calculate
your average.