seperating days of week in a database

[chrisandfarah]

My database has columns headed with food sales, bar sales, net sales, etc..
The rows are numbered by day of week, with the day of the week in the next
column. Is it possible to determine the average for each type of sale for
each day of the week. For example, what are my average food sales on fridays
and wednesdays?

I would like to do this without manually changing my formulas every month.

Thanks

[Duke Carey]

Yes, you can do this with a formula, but there is probably an easier
alternative for you. Have you looked into Pivot tables?

"chrisandfarah" wrote:

> My database has columns headed with food sales, bar sales, net sales, etc..
> The rows are numbered by day of week, with the day of the week in the next
> column. Is it possible to determine the average for each type of sale for
> each day of the week. For example, what are my average food sales on fridays
> and wednesdays?
>
> I would like to do this without manually changing my formulas every month.
>
> Thanks
>