dversloot1
Board Regular
- Joined
- Apr 3, 2013
- Messages
- 113
Hello,
I've created 2 dynamic ranges:
Last30Days which captures the range of the past 30 days formatted as Short Dates.
Last30DayCOGS which captures the range of cost of goods sold on those past 30 days.
I'm trying to get the average sale by day of the week for the past 30 days.
Monday Average = Sumif(Last30Days,"Monday",Last30DayCOGS) / countif(Last30Days, "Monday")
Tuesday Average = Sumif(Last30Days,"Tuesday",Last30DayCOGS) / countif(Last30Days,"Tuesday")
Any Idea how I can have this calculated for all each day of the week?
I've created 2 dynamic ranges:
Last30Days which captures the range of the past 30 days formatted as Short Dates.
Last30DayCOGS which captures the range of cost of goods sold on those past 30 days.
I'm trying to get the average sale by day of the week for the past 30 days.
Monday Average = Sumif(Last30Days,"Monday",Last30DayCOGS) / countif(Last30Days, "Monday")
Tuesday Average = Sumif(Last30Days,"Tuesday",Last30DayCOGS) / countif(Last30Days,"Tuesday")
Any Idea how I can have this calculated for all each day of the week?