Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count specific numbers in a column
Hi,
Is there a way to count specific numbers in a column and enter the number into a new cell. For example: A B C D 1 1 1 2 3 2 1 2 3 4 3 2 4 2 5 2 6 3 7 3 8 3 9 3 Column A is the data, in B2 I want a function that counts the number of "1"s in column A, in C2 the same function that counts the number of "2"s in A, and so on. I am in need of the function. Thanks in advance. Marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count specific numbers in a column
in B2 enter
=COUNTIF($A1:$A100,B1) HTH "JimmyH" wrote: Hi, Is there a way to count specific numbers in a column and enter the number into a new cell. For example: A B C D 1 1 1 2 3 2 1 2 3 4 3 2 4 2 5 2 6 3 7 3 8 3 9 3 Column A is the data, in B2 I want a function that counts the number of "1"s in column A, in C2 the same function that counts the number of "2"s in A, and so on. I am in need of the function. Thanks in advance. Marc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count specific numbers in a column
+COUNTIF(A1:A9,B1) "JimmyH" wrote in message news:aooyd.563758$nl.272435@pd7tw3no... Hi, Is there a way to count specific numbers in a column and enter the number into a new cell. For example: A B C D 1 1 1 2 3 2 1 2 3 4 3 2 4 2 5 2 6 3 7 3 8 3 9 3 Column A is the data, in B2 I want a function that counts the number of "1"s in column A, in C2 the same function that counts the number of "2"s in A, and so on. I am in need of the function. Thanks in advance. Marc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count specific numbers in a column
"Jim Thomlinson" =COUNTIF($A1:$A100,B1) Perfecto. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count a specific month in a column | Excel Worksheet Functions | |||
Count the cell contain a specific numbers in a range | Excel Discussion (Misc queries) | |||
How do I count cells that contain one of several specific numbers? | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions |