How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,836
- Office Version
- 2010
- Platform
- Windows
What formula would I use in B1 to find the average of "Mondays" with a value please. In the example the values are 10 and 5 so I'm looking for a return of 7.5 please.
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Monday | |||
2 | ||||
3 | Monday | 5 | ||
4 | Tuesday | 2 | ||
5 | Wednesday | 2 | ||
6 | Monday | 10 | ||
7 | Sunday | 2 | ||
8 | Monday | |||
9 | Tuesday | 2 | ||
Sheet1 |