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

Best Regards
Viks

"RagDyeR" wrote:

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!
================================================== ===


"Viks" wrote in message
...
How do I count if values in a table that are =100 and <=200?