software

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) ?

Peteone way

=COUNTIF(A10:G11,quot;=45quot;) COUNTIF(I10:L11,quot;=45quot;)

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

quot;Cliffquot; gt; wrote in message
...
gt;I am trying to find a function to count the occurrences of a specific
gt;number
gt; in a range of cells in 2 adjacent rows and 45 adjacent columns.
gt;
gt; Also, how would the formula change if the rows and columns were not
gt; adjacent?
gt; Any sugestions would help.
gt;
gt; --
gt; 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.
--
Cliffquot;Bill Kuundersquot; wrote:

gt; one way
gt;
gt; =COUNTIF(A10:G11,quot;=45quot;) COUNTIF(I10:L11,quot;=45quot;)
gt;
gt; or
gt; =COUNTIF(A10:G11,45) COUNTIF(I10:L11,45)
gt;
gt; change the ranges to suit
gt; and you could store the number 45 in a cell........... A2
gt;
gt; =COUNTIF(A10:G11,A2) COUNTIF(I10:L11,A2)
gt;
gt; --
gt; Greetings from New Zealand
gt; Bill K
gt;
gt; quot;Cliffquot; gt; wrote in message
gt; ...
gt; gt;I am trying to find a function to count the occurrences of a specific
gt; gt;number
gt; gt; in a range of cells in 2 adjacent rows and 45 adjacent columns.
gt; gt;
gt; gt; Also, how would the formula change if the rows and columns were not
gt; gt; adjacent?
gt; gt; Any sugestions would help.
gt; gt;
gt; gt; --
gt; gt; Cliff
gt;
gt;
gt;