BTW,
*Not* really an array formula.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Domenic" wrote in message
...
Try the following...

=SUM(COUNTIF(A1:C3,{3,11,54}))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Dillenger wrote:

Hello,

I'm trying to figure out how to calculate the occurance of multiple
numbers
in multiple cell range. For example:

A1 B1 C1
3 11 54
2 5 45
3 11 54

I would like to calculate how many times 3, 11 and 54 came up... In this
case 2.