function contif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Isaías. - 06 Mar 2007 11:17 GMT

I´ve a list of numbers and want to use the count how many of this is within
the ranges

Reply to this Message

Mike - 06 Mar 2007 11:37 GMT

Checks the range A2 - A10 for numbers >=5 and <=20.
=COUNTIF(A2:A10,">=5")-COUNTIF(A2:A10,">20")

Mike

> I´ve a list of numbers and want to use the count how many of this is within
> the ranges

Reply to this Message

Martin Fishlock - 06 Mar 2007 13:09 GMT

Hi:

Another way to do it is sumproduct:

=sumproduct(--(A2:A10>=5),--(A2:A10<20))

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> Checks the range A2 - A10 for numbers >=5 and <=20.
> =COUNTIF(A2:A10,">=5")-COUNTIF(A2:A10,">20")
[quoted text clipped - 3 lines]
> > I´ve a list of numbers and want to use the count how many of this is within
> > the ranges

Reply to this Message