I am completely new to Excel. Please have mercy :)

I have a table of numbers (40 columns by 10 rows). In each cell is one
number.

I want to analyze the table of numbers for a given number and indicate
a "0" for no matches and the count if there is 1 or more matches.

Example using smaller table of data:

Say A1 to E2 is as follows:
1 3 9 5 20
5 4 2 5 5

I want A5 (the cell with the formula) to examine A1 to E2 for "5."
Since there are 4 occurances of "5" I want A5 to display "4." Likewise,
if I want A6 to examince A1 to E2 for "99" I want A6 to display "0" as
there are no 99s present in A1 to E2.

What formula should I use for such a purpose as this?

Thanks in advance :)


--
luposlipophobia
------------------------------------------------------------------------
luposlipophobia's Profile: http://www.excelforum.com/member.php...o&userid=35655
View this thread: http://www.excelforum.com/showthread...hreadid=554391