Count number of times a specific number is displayed in a cell ran

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the times a specific character appears in a cell 3
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
Want to count all repeated number only once in Excel 2007. 2
Excel 2003 Counting multiple number entries in a single cell 6
Count a number in a range with cells containing more than one numb 12
count number of cells 4
Is there a shorten way to increase the value 1
Finding count of unique number within a specific criteria? 7

Top