Excel COUNTIF function

B

Bob Phillips

=COUNTIF(A:A,">=100")-COUNTIF(A:A,">200")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
R

RagDyeR

One way:

=SUMPRODUCT((A1:A30>=100)*(A1:A30<=200))


Another way:

=COUNTIF(A1:A30,">=100")-COUNTIF(A1:A30,">200")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


How do I count if values in a table that are >=100 and <=200?
 
V

Viks

Thanks, much appreciated! The second option works really cool and easy.

Best Regards
Viks
 
Top