| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I have a range of cells (D$9
 350) and I want to count the number ofinstances that a number in the cell range is between 100 and 400. I keep getting errors. |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
One way:
This also counts 100 and 400. =COUNTIF(D9 350,">=100")-COUNTIF(D9350,">400")-- Biff Microsoft Excel MVP "LAWNDALE" <(E-Mail Removed)> wrote in message news:9E9A4606-F209-4433-B080-(E-Mail Removed)... >I have a range of cells (D$9 350) and I want to count the number of> instances that a number in the cell range is between 100 and 400. I keep > getting errors. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Very helpful. Thanks.
"LAWNDALE" wrote: > I have a range of cells (D$9 350) and I want to count the number of> instances that a number in the cell range is between 100 and 400. I keep > getting errors. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
You're welcome!
-- Biff Microsoft Excel MVP "LAWNDALE" <(E-Mail Removed)> wrote in message news:E1743429-C9ED-4901-AADB-(E-Mail Removed)... > Very helpful. Thanks. > > "LAWNDALE" wrote: > >> I have a range of cells (D$9 350) and I want to count the number of>> instances that a number in the cell range is between 100 and 400. I keep >> getting errors. |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countif with numbers and words | Joe | Microsoft Excel Worksheet Functions | 4 | 7th Oct 2009 11:14 AM |
| Countif function for Even and Odd numbers | Jezzy | Microsoft Excel Worksheet Functions | 34 | 25th Oct 2008 07:16 PM |
| COUNTIF for range of numbers | =?Utf-8?B?Ymltc2V1bg==?= | Microsoft Excel Misc | 3 | 24th Jan 2006 02:40 PM |
| Countif for numbers between x and y | don | Microsoft Excel Worksheet Functions | 4 | 5th May 2005 01:01 PM |
| COUNTIF - Between Two Numbers | Dave | Microsoft Excel Worksheet Functions | 1 | 4th Dec 2003 09:14 PM |
