software

How do I count if values in a table that are gt;=100 and lt;=200?

=COUNTIF(A:A,quot;gt;=100quot;)-COUNTIF(A:A,quot;gt;200quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Viksquot; gt; wrote in message
...
gt; How do I count if values in a table that are gt;=100 and lt;=200?
One way:

=SUMPRODUCT((A1:A30gt;=100)*(A1:A30lt;=200))Another way:

=COUNTIF(A1:A30,quot;gt;=100quot;)-COUNTIF(A1:A30,quot;gt;200quot;)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;Viksquot; gt; wrote in message
...
How do I count if values in a table that are gt;=100 and lt;=200?
Thanks, much appreciated! The second option works really cool and easy.

Best Regards
Viks

quot;RagDyeRquot; wrote:

gt; One way:
gt;
gt; =SUMPRODUCT((A1:A30gt;=100)*(A1:A30lt;=200))
gt;
gt;
gt; Another way:
gt;
gt; =COUNTIF(A1:A30,quot;gt;=100quot;)-COUNTIF(A1:A30,quot;gt;200quot;)
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt;
gt; quot;Viksquot; gt; wrote in message
gt; ...
gt; How do I count if values in a table that are gt;=100 and lt;=200?
gt;
gt;
gt;

Thanks Bob, much appreciated, works really well and easy.

Best Regards
Viks

quot;Bob Phillipsquot; wrote:

gt; =COUNTIF(A:A,quot;gt;=100quot;)-COUNTIF(A:A,quot;gt;200quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Viksquot; gt; wrote in message
gt; ...
gt; gt; How do I count if values in a table that are gt;=100 and lt;=200?
gt;
gt;
gt;