Excel 'bingo' count.

[John]

I want to do something in Excel and I believe the simplest example is
a 'bingo' card.

What I want to do is check a 'bingo' matrix (say b1 to g5) that
contains numbers and words with a 'draw' matrix (say a2 to a100) of
numbers only and count the number of times a number from a2:a100
appears in b1:g5 matrix.

Any ideas?
John

 

[pmarino]

in h2 put =countif(b$1:g$5, a2)
copy to h3:h10

 

[John]

in h2 put =countif(b$1:g$5, a2)
copy to h3:h100

Then sum h3:100. Hmm...not elegant but it'll work. THANKS