Searching Columns and Rows

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

Have you tried COUNTIF(range,criterion) ?

Pete

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" <[email protected]> wrote in message
news:[email protected]...
>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

Thanks, I got the formulas to work when referencing a range of cells with
numbers directly entered, but they would not work with a range of cells that
had other formulas totaling a number in them.
--
Cliff


"Bill Kuunders" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>