Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count
I need to know how to count the number of times a specific number appears
within a range. ie. cell A:1 thru A:1000 - how many times was the number 3 entered. Disregard all other numbers that may of been entered. |
#2
|
|||
|
|||
Try...
=COUNTIF(A1:A1000,3) Hope this helps! In article , Alex C <Alex wrote: I need to know how to count the number of times a specific number appears within a range. ie. cell A:1 thru A:1000 - how many times was the number 3 entered. Disregard all other numbers that may of been entered. |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
If a cell could have more than 1 occurrence of 3, and you want to count all,
then use =SUMPRODUCT(--(LEN(A1:A1000)-LEN(SUBSTITUTE(A1:A1000,"3","")))) -- HTH Bob Phillips "Alex C" <Alex wrote in message ... I need to know how to count the number of times a specific number appears within a range. ie. cell A:1 thru A:1000 - how many times was the number 3 entered. Disregard all other numbers that may of been entered. |
#5
|
|||
|
|||
You could also place a subtotal function using the count option two cells
below the range, then place a filter on the range. This way, you can quickly get the count of 3's, then 5's, 7's, etc., without having to re-write the countif function constantly. First, in cell A1002 - =subtotal(2,a1:a1000) Then, highlight A1:A1000 and select Data/Filter/AutoFilter. Use the filter box to select the value that you want to count and the subtotal function will automatically count it. "Alex C" wrote: I need to know how to count the number of times a specific number appears within a range. ie. cell A:1 thru A:1000 - how many times was the number 3 entered. Disregard all other numbers that may of been entered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |