Excel COUNTIF function

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Viks" <[email protected]> wrote in message
news:[email protected]...
> How do I count if values in a table that are >=100 and <=200?

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" <[email protected]> wrote in message
news:[email protected]...
How do I count if values in a table that are >=100 and <=200?

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" <[email protected]> wrote in message
> news:[email protected]...
> How do I count if values in a table that are >=100 and <=200?
>
>
>

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

Best Regards
Viks

"Bob Phillips" wrote:

> =COUNTIF(A:A,">=100")-COUNTIF(A:A,">200")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Viks" <[email protected]> wrote in message
> news:[email protected]...
> > How do I count if values in a table that are >=100 and <=200?
>
>
>