I am trying to average data for multiple locations and multiple days- example below
1st 2nd 3rd 4th
vermont 1.5 1.8 .3 1.2
vermont .6 .8 1.2 .9
vermont etc...
vermont
dallas
dallas
new york
new york
new york
I want to pull an average for all four days for each location. Ideas? When I do =AVERAGEIF(Markets!A:A,Districts!A2,Markets!C2:H13) it is only pulling the average from the first day listed not all of them.
Bookmarks