D
DaS
In column B I have the dates listed from 01/01/07 through 10/31/2007. In
column E I have totals for each day. What I would like to do is have an
average for each day of the week, i.e., Mondays from 01/01/2007-10/31/2007 =
219, Tuesdays from 01/01/2007-10/31/2007= 250 and so on. I know that I will
have to have a separate cell doing it's own calculation for each weekday, I'm
just not that savvy working with the Sumifs, countifs, or day functions.
Thanks!
column E I have totals for each day. What I would like to do is have an
average for each day of the week, i.e., Mondays from 01/01/2007-10/31/2007 =
219, Tuesdays from 01/01/2007-10/31/2007= 250 and so on. I know that I will
have to have a separate cell doing it's own calculation for each weekday, I'm
just not that savvy working with the Sumifs, countifs, or day functions.
Thanks!