one way

=COUNTIF(A10:G11,"=45")+COUNTIF(I10:L11,"=45")

or
=COUNTIF(A10:G11,45)+COUNTIF(I10:L11,45)

change the ranges to suit
and you could store the number 45 in a cell........... A2

=COUNTIF(A10:G11,A2)+COUNTIF(I10:L11,A2)

--
Greetings from New Zealand
Bill K

"Cliff" wrote in message
...
I am trying to find a function to count the occurrences of a specific
number
in a range of cells in 2 adjacent rows and 45 adjacent columns.

Also, how would the formula change if the rows and columns were not
adjacent?
Any sugestions would help.

--
Cliff