Count Customers by Account Size
 

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

How would you approach?

Count Customers by Account Size
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"porter444" wrote in message
...
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

How would you approach?

Count Customers by Account Size
 

Excel 2007 PivotTable
No formulas, no code.
Count customers per sales range, time slot.
http://www.mediafire.com/file/nehnf5...01_22_10a.xlsx