Count Customers by Account Size

[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

How would you approach?

 

[Bernard Liengme]

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

 

[p45cal]

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

how would you approach?

=countif($e$13:$e$31,"<100000")
=countif($e$13:$e$31,"<200000")-countif($e$13:$e$31,"<100000")
=countif($e$13:$e$31,"<300000")-countif($e$13:$e$31,"<200000")
=countif($e$13:$e$31,"<400000")-countif($e$13:$e$31,"<300000")
=countif($e$13:$e$31,">=400000")

 

[Herbert Seidenberg]

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