Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Countif using less than or greater than criteria

1,281 views
Skip to first unread message

Ron Coderre

unread,
Mar 12, 2008, 1:21:41 PM3/12/08
to
Try this:

=COUNTIF(D11:D15,"<"&K2)-COUNTIF(D11:D15,"<="&I2)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Kim B." <Ki...@discussions.microsoft.com> wrote in message
news:C62A49A9-4114-4456...@microsoft.com...
>I have a list of data in cells d11:d15. I want to be able to count how
>many
> of the data points fall within a certain numeric range (ie less than 100
> but
> greater than 50) but I want to be able to reference a specific cell
> containing the criteria rather than using '100' or '50' in the formula.
> In
> my worksheet 50 is in cell I2 and 100 is in cell K2.


Ron Coderre

unread,
Mar 12, 2008, 1:24:55 PM3/12/08
to
Couple other options:

=SUMPRODUCT((D11:D15>I2)*(D11:D15<K2))
or
=SUMPRODUCT(--(D11:D15>I2),--(D11:D15<K2))

Jim Thomlinson

unread,
Mar 12, 2008, 1:30:05 PM3/12/08
to
Try this...

=SUMPRODUCT((D11:D15>=I2) * (D11:D15<=K2))

here is a link to an explanation of sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson

0 new messages