Average

[How_Do_I]

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

 

[PatOBrien198]

=AVERAGEIF(A3:A17,A1,B3:B17)

of course make the "17" big enough to get all rows.

 

[FormR]

Hi,

=AVERAGEIFS(B3:B9,A3:A9,A1)

 

[How_Do_I]

Thanks Pat and FormR