| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count number of times a specific number is displayed in a cell ran
How can I count the number of cells which contain a specific number? For
example, a b c d e 1 23 11 45 32 61 2 5 86 143 21 97 3 14 56 64 13 9 4 63 51 111 32 76 Cells A1:E4 = 8, the number "1" is displayed in 8 cells throughout the specified cell range. |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--ISNUMBER(FIND(1,A1:E4)))
"subs" wrote in message ... How can I count the number of cells which contain a specific number? For example, a b c d e 1 23 11 45 32 61 2 5 86 143 21 97 3 14 56 64 13 9 4 63 51 111 32 76 Cells A1:E4 = 8, the number "1" is displayed in 8 cells throughout the specified cell range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
| SPECIFIC WORD COUNT FROM A RANGE | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
