| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count specific item???
Howdy all, I have a column that contains a specific number in each cell, the numbers are 11 thru 39. Each number represents an area I deliver to. How can I count how many times each specific number is displayed in the column, so I can see how many times I delivered to that area. Thanks for any help! Jeff -- Jeff32 ------------------------------------------------------------------------ Jeff32's Profile: http://www.excelforum.com/member.php...o&userid=34204 View this thread: http://www.excelforum.com/showthread...hreadid=539655 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count specific item???
You could make a list of the numbers and in the next column
=countif(a:a,b1) copy down to number 39 assuming the numbers you want to count are in col a and the numbers to evaluate are in col b -- Don Guillett SalesAid Software "Jeff32" wrote in message ... Howdy all, I have a column that contains a specific number in each cell, the numbers are 11 thru 39. Each number represents an area I deliver to. How can I count how many times each specific number is displayed in the column, so I can see how many times I delivered to that area. Thanks for any help! Jeff -- Jeff32 ------------------------------------------------------------------------ Jeff32's Profile: http://www.excelforum.com/member.php...o&userid=34204 View this thread: http://www.excelforum.com/showthread...hreadid=539655 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count specific item???
Jeff
The FREQUENCY Function is tailor-made for this operation. The column is the Data Array An adjacent column with the numbers 11-39 is the Bins Array. Note: this is an Array function so output cells must be pre-selected and CTRL + SHIFT + ENTER used to enter the formula. Gord Dibben MS Excel MVP On Sun, 7 May 2006 10:53:19 -0500, Jeff32 wrote: Howdy all, I have a column that contains a specific number in each cell, the numbers are 11 thru 39. Each number represents an area I deliver to. How can I count how many times each specific number is displayed in the column, so I can see how many times I delivered to that area. Thanks for any help! Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count cells beginning with specific letter? | New Users to Excel | |||
| Count rows with specific date | Excel Discussion (Misc queries) | |||
| Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count the number of specific values in a cell | Excel Worksheet Functions | |||
Linear Mode
