Enter numbers that represent the bins you want to group values into. Make a selection the same size as the range that contains bins, or one greater if want to include the extra item. Enter the FREQUENCY function as an array formula using Control+Shift+Enter.
Europe spends much per average customer. The global ranking shows Europe is doing pretty well, considering Norway is the number two with $2,448 spent online per average customer in 2015. Only the average revenue per user in Hong Kong was higher, with $2,868.
Quick Answer. As of 2014, an average person spends $3,735 per month. This monthly average amounts to $44,820 per year and this is approximately $5,000 less than the average consumer spent in 2007, when the average was $49,648. Continue Reading.