I am trying count the total number of people who live within a certain mileage of a store, and who spent a certain amount of money in the month of January based on preset mileage ranges and spend amounts. I am also trying to count the number of trips these group of individuals made in each segment. In addition, I have a column in the far right that is to calculate the average spend of these individuals for each segment.
Attached is my test worksheet. You can see the fields I am looking to fill in with a formula on the top (in yellow), with the data set below starting on row 26. Note the data set includes data for January, February and March. Once I see the formula for January I will be able to use this for February, March and the promotion month.
Any help would be wonderful.
Thanks!
Bookmarks