| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Try this:
=COUNTIF(D11  15,"<"&K2)-COUNTIF(D1115,"<="&I2)Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kim B." <(E-Mail Removed)> wrote in message news:C62A49A9-4114-4456-A637-(E-Mail Removed)... >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. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Couple other options:
=SUMPRODUCT((D11 15>I2)*(D1115<K2))or =SUMPRODUCT(--(D11 15>I2),--(D1115<K2))-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Kim B." <(E-Mail Removed)> wrote in message news:C62A49A9-4114-4456-A637-(E-Mail Removed)... >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. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Try this...
=SUMPRODUCT((D11 15>=I2) * (D1115<=K2))here is a link to an explanation of sumproduct http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Kim B." wrote: > 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. |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| COUNTIF greater than one column and less than another | Nadine | Microsoft Excel Worksheet Functions | 5 | 8th May 2009 07:10 PM |
| CountIf cell value greater than 14 | =?Utf-8?B?TGVz?= | Microsoft Excel Programming | 5 | 20th Nov 2007 09:13 PM |
| CountIf Greater Than/Find Greater Than | Sisilla | Microsoft Excel Programming | 12 | 6th Oct 2006 08:04 PM |
| Excel to COUNTIF if number greater than one but less than another | =?Utf-8?B?Um9vc3Rlcjg=?= | Microsoft Excel Worksheet Functions | 2 | 24th Oct 2005 10:35 PM |
| countif greater/less than argument | =?Utf-8?B?bm1lIzE=?= | Microsoft Excel Worksheet Functions | 3 | 18th Oct 2005 07:36 AM |
