seperating days of week in a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Yes, you can do this with a formula, but there is probably an easier
alternative for you. Have you looked into Pivot tables?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
How do I average every 3rd cell in a column of a spreadsheet? 3
Average with Condition 4
Countif w/semicolon separated values AND Filter 1
Average Calculation 4
Adding Days 2
Sorting Rows 1
Define Name - same name for multiple cells on multiple sheets 6

Back
Top