Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
subs
 
Posts: n/a
Default 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   Report Post  
N Harkawat
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i count the number of conditional formatted cells? kate Excel Discussion (Misc queries) 2 May 16th 05 10:47 PM
how 2 Count number of cells that have specific condition format? daveydavey Excel Worksheet Functions 2 May 4th 05 02:06 PM
SPECIFIC WORD COUNT FROM A RANGE Nigel Excel Discussion (Misc queries) 6 April 28th 05 01:52 PM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 11:39 PM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 06:54 PM


All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"