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

S

subs

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

get a list of sequence number that meet 3 criteria 0
LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THATCOLUMN 3
Count the times a specific character appears in a cell 3
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
Auto calculate 1
Is there a shorten way to increase the value 1
How to get the array like this? 6
I'm trying to do a "count" function at the end of a dynamic pivot table 0

Top