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

Searching Columns and Rows
 

Have you tried COUNTIF(range,criterion) ?

Pete

Searching Columns and Rows
 

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

Searching Columns and Rows
 

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" 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