Average with Multiple Criteria

I am trying to figure out the correct way to average the number trips and spend by customers in a certain mileage radius over a 3 month period, and then populate those totals into specific segmented "spend" categories. My confusion is with the proper way to generate the correct average. Do I summarize the data for each month first, then divide by the number of months, or do I just average the entire data base.

Attached is a sample of what I am trying to do. The yellow fields would be populated with the average for each category from the entire data set.

Thanks in advance.
Test Avg.xlsx

Thank you for your reply. For some reason this formula did not work.

In regards to the average questions. I was trying to determine the average spend over a 3 month period vs. an entire calendar year. My sense is that would be mathmatically correct. The confusion I am having is trying to see if I need to first summarize each month, then divide by the number of months to create an average for those 3 months.... or generate an average based on the 3 month data set.

I hope that better clarifies this.

Thanks!

Thank you for the update. I looked at the formulas and had a question.

If I change cell H22 to $1500 it changes the value in both cells E4 and E5 to 1500. It should only change cell E4. Also, the averages should always be within the preset shopper spend ranges, right? For example, the results in cell E9 fall outside the range.

Also, in columns titled Avg. # of trips (i.e. Column E), I was actually hoping to show the average number of vs. average spend, as the average spend would be a calculation shown in column P.

I hope this makes sense as I appreciate your feedback.

On a final note, just to clarify the correct way calculate the average, I am looking to just cacluate the average of 3 months and not a full year as this project is for specific promotions that compare the promo month the the activity from these same customers from the previous 3 (non-promo) months.

Thanks again!