average for day-of-week (eg. avg for monday, avg for tue, etc)

[saimike]

Hi

I have a column of data like this:

Date, sales
1/2,1
1/3,2
1/4,3
1/5,4
1/6,5
1/7,6
1/8,7

I want the sales average for Monday, Tue, etc. How would I do that without using array formulas?

[Haseeb Avarakkan]

try SUMPRODUCT,

=SUMPRODUCT(--(TEXT($A$2:$A$20,"ddd;;;")="Mon"),$B$2:$B$20)/SUMPRODUCT(--(TEXT($A$2:$A$20,"ddd;;;")="Mon"))

[saimike]

Thanks Haseeb, I'll try that.