software

I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.

I came up with
=COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))

Range looks like
Game 1Game 2Game 3
12014695
13314750
000
166146135
000
121159168
123170125
000
121121121
155145140
140167137

Any help is greatly appreciated.

=COUNTIF(F52:H73gt;0,F52:H73)-COUNTIF(F52:H73gt;=125,F52:H73)
This counts everything above 0, then subtracts the count of everything 125
or greater.quot;Jonquot; wrote:

gt; I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.
gt;
gt; I came up with
gt; =COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))
gt;
gt; Range looks like
gt; Game 1Game 2Game 3
gt; 12014695
gt; 13314750
gt; 000
gt; 166146135
gt; 000
gt; 121159168
gt; 123170125
gt; 000
gt; 121121121
gt; 155145140
gt; 140167137
gt;
gt; Any help is greatly appreciated.

When I copy and paste the formula it only shows the formula not the result.

quot;bpeltzerquot; wrote:

gt; =COUNTIF(F52:H73gt;0,F52:H73)-COUNTIF(F52:H73gt;=125,F52:H73)
gt; This counts everything above 0, then subtracts the count of everything 125
gt; or greater.
gt;
gt;
gt; quot;Jonquot; wrote:
gt;
gt; gt; I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.
gt; gt;
gt; gt; I came up with
gt; gt; =COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))
gt; gt;
gt; gt; Range looks like
gt; gt; Game 1Game 2Game 3
gt; gt; 12014695
gt; gt; 13314750
gt; gt; 000
gt; gt; 166146135
gt; gt; 000
gt; gt; 121159168
gt; gt; 123170125
gt; gt; 000
gt; gt; 121121121
gt; gt; 155145140
gt; gt; 140167137
gt; gt;
gt; gt; Any help is greatly appreciated.

For a multiple condition count you have to change functions

=SUMPRODUCT(--(F52:H73gt;0),--(F52:H73lt;125)

To explain:
(F52:H73gt;0) generates an array of TRUE/FALSE values corresponding to each
cell in the range and whether each cell's value passes or fails the test.
The double negatives convert the trues to 1s and the falses to 0s. Same for
the other test. The sumproduct function multiples the arrays together.
Only the cells that pass both tests will resolve to a 1, for all the other
cells represented in the arrays will have at least a single zero, and zero
times anythng is...
quot;Jonquot; gt; wrote in message
...
gt;I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.
gt;
gt; I came up with
gt; =COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))
gt;
gt; Range looks like
gt; Game 1 Game 2 Game 3
gt; 120 146 95
gt; 133 147 50
gt; 0 0 0
gt; 166 146 135
gt; 0 0 0
gt; 121 159 168
gt; 123 170 125
gt; 0 0 0
gt; 121 121 121
gt; 155 145 140
gt; 140 167 137
gt;
gt; Any help is greatly appreciated.
Duke,

Thanks that did it. I think I understand your explanation. New to Excel
and Loving it.

Thanks again.

quot;Duke Careyquot; wrote:

gt; For a multiple condition count you have to change functions
gt;
gt; =SUMPRODUCT(--(F52:H73gt;0),--(F52:H73lt;125)
gt;
gt; To explain:
gt; (F52:H73gt;0) generates an array of TRUE/FALSE values corresponding to each
gt; cell in the range and whether each cell's value passes or fails the test.
gt; The double negatives convert the trues to 1s and the falses to 0s. Same for
gt; the other test. The sumproduct function multiples the arrays together.
gt; Only the cells that pass both tests will resolve to a 1, for all the other
gt; cells represented in the arrays will have at least a single zero, and zero
gt; times anythng is...
gt;
gt;
gt;
gt; quot;Jonquot; gt; wrote in message
gt; ...
gt; gt;I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.
gt; gt;
gt; gt; I came up with
gt; gt; =COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))
gt; gt;
gt; gt; Range looks like
gt; gt; Game 1 Game 2 Game 3
gt; gt; 120 146 95
gt; gt; 133 147 50
gt; gt; 0 0 0
gt; gt; 166 146 135
gt; gt; 0 0 0
gt; gt; 121 159 168
gt; gt; 123 170 125
gt; gt; 0 0 0
gt; gt; 121 121 121
gt; gt; 155 145 140
gt; gt; 140 167 137
gt; gt;
gt; gt; Any help is greatly appreciated.
gt;
gt;
gt;

=COUNTIF(F52:H73,quot;gt;0quot;)-COUNTIF(F52:H73,quot;gt;=125quot;)

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Jonquot; gt; wrote in message
...
gt; I have a range F52:H73, I am trying to count the numbersgt;0,and lt;125.
gt;
gt; I came up with
gt; =COUNT(IF(F52:H73lt;gt;0lt;125,F52:H73))
gt;
gt; Range looks like
gt; Game 1 Game 2 Game 3
gt; 120 146 95
gt; 133 147 50
gt; 0 0 0
gt; 166 146 135
gt; 0 0 0
gt; 121 159 168
gt; 123 170 125
gt; 0 0 0
gt; 121 121 121
gt; 155 145 140
gt; 140 167 137
gt;
gt; Any help is greatly appreciated.