| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Okay I know how array formulas work but I'm having trouble with the
following. I want to count the number of times each value in column D is less than each corresponding value in column B. What I have is {=COUNTIF(D2  100, "<B2:B100")}but it doesn't work (it always returns 0). Any ideas? |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
try this NON-array entered formula
=SUMPRODUCT((d7:d18<b7:b18)*1) -- Don Guillett SalesAid Software (E-Mail Removed) "Phil" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Okay I know how array formulas work but I'm having trouble with the > following. I want to count the number of times each value in column D > is less than each corresponding value in column B. What I have is > > {=COUNTIF(D2 100, "<B2:B100")}> > but it doesn't work (it always returns 0). > > Any ideas? > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
One way (array-entered):
=SUM(--(D2 100<B2:B100))In article <(E-Mail Removed)>, Phil <(E-Mail Removed)> wrote: > Okay I know how array formulas work but I'm having trouble with the > following. I want to count the number of times each value in column D > is less than each corresponding value in column B. What I have is > > {=COUNTIF(D2 100, "<B2:B100")}> > but it doesn't work (it always returns 0). > > Any ideas? |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| RE: how to compare a date range another range | Jacob Skaria | Microsoft Excel Programming | 1 | 22nd Apr 2009 02:31 AM |
| Compare each value in a range to each value in another range | trigo1@cox.net | Microsoft Excel Discussion | 6 | 24th Sep 2006 01:14 PM |
| Compare range with another range in other workbook | =?Utf-8?B?QXJqYW4=?= | Microsoft Excel Worksheet Functions | 2 | 15th Nov 2005 03:31 PM |
| Compare a selected Range with a Named range and select cells that do not exist | PCLIVE | Microsoft Excel Programming | 1 | 18th Oct 2005 07:09 PM |
| Excel range ! versus : | Henning | Microsoft Excel Misc | 3 | 22nd Apr 2004 03:36 PM |
