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?
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?
Last edited by saimike; 01-13-2012 at 04:31 PM.
try SUMPRODUCT,
=SUMPRODUCT(--(TEXT($A$2:$A$20,"ddd;;;")="Mon"),$B$2:$B$20)/SUMPRODUCT(--(TEXT($A$2:$A$20,"ddd;;;")="Mon"))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thanks Haseeb, I'll try that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks