| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average Function with Day of Week Criteria
This is for Excel 2000.
I want to compute averages based on the day of the week listed in another column but within the same row. I already have the day of the week figured out, column A has numbers 1-7, 1=Sunday, 2=Monday, etc. What I want is to take the AVERAGE of B1:B200, *if* the value in column A=1, or whatever number or numbers I specify. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average function and two criteria | Excel Worksheet Functions | |||
| Average of numbers within a range meeting certain criteria | Excel Worksheet Functions | |||
| Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| Using the average function | Excel Worksheet Functions | |||
Threaded Mode
