Count number of times a specific number is displayed in cells

How can you count the number of times a specific number is displayed in a
group of cells?

=countif(A1:Z26,123)

if some of the cells contain the number 123

or in VBA

msgbox Application.Countif(Range("A1:Z26"),123)

--
Regards,
Tom Ogilvy

"subs" <[email protected]> wrote in message
news:[email protected]...
> How can you count the number of times a specific number is displayed in a
> group of cells?
>
>