Count Customers by Account Size

  • Thread starter Thread starter porter444
  • Start date Start date
P

porter444

I have a listing of thousands of customers and need to count how many fall
into specific groups based on the size of the account (how much we sold to
them).

Example of desired result:

<$100K - 50 customers
$100K - 80 customers
$200K - 100 customers
$300K - 90 customers
$400K - 60 customers
Click to expand...

How would you approach?
 
Suppose in your list the sales figures are in column B
I will assume column Z is empty
In Z1:Z11 enter 0,100000,200000,....1000000
Select AA1:AA12 (one extra cell);
Type =FREQUENCY(B1:B2000,Z1:Z11) and commit with CTRL+SHIFT+ENTER since this
is any array formula
(Adjust the B range as needed - in XL2007 use B:B)


Or, read Help on how to use the Histogram tool in Data Analysis
best wishes
 
Back
Top