Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count my Customers | Excel Worksheet Functions | |||
account # entry needs to return the account description | Excel Worksheet Functions | |||
Count number of 2008 invoices for customers | Excel Worksheet Functions | |||
top ten customers by transaction count by product | Excel Worksheet Functions | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) |