Count Cells Within 10 of a Cell Value
in [Functions]
|
From: Missbrooke06 on 10 Mar 2010 15:00 I need a formula that calculates how many out of a range of cells are within 10 of another cell. For instance, I have cells F3 through U3. I want to know how many of them are either 10 above or 10 below the value in cell V3. If cell V3 equals 20, than I want to know how many are between 10 and 20 and how many are between 20 and 30. Ideally, this would be in the same formula but two seperate formulas is also acceptable.
From: Don Guillett on 10 Mar 2010 15:12 Look in the help index for SUMIF. You can combine -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Missbrooke06" <Missbrooke06(a)discussions.microsoft.com> wrote in message news:B5B85CF3-CA85-4CD5-A8FC-419CEB6B0FBD(a)microsoft.com... >I need a formula that calculates how many out of a range of cells are >within > 10 of another cell. For instance, I have cells F3 through U3. I want to > know > how many of them are either 10 above or 10 below the value in cell V3. If > cell V3 equals 20, than I want to know how many are between 10 and 20 and > how > many are between 20 and 30. Ideally, this would be in the same formula but > two seperate formulas is also acceptable. > >
From: Mike H on 10 Mar 2010 15:14 Hi, Try this =COUNTIF(F2:U2,">="&V2/2)-COUNTIF(F2:U2,">"&V2*1.5) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Missbrooke06" wrote: > I need a formula that calculates how many out of a range of cells are within > 10 of another cell. For instance, I have cells F3 through U3. I want to know > how many of them are either 10 above or 10 below the value in cell V3. If > cell V3 equals 20, than I want to know how many are between 10 and 20 and how > many are between 20 and 30. Ideally, this would be in the same formula but > two seperate formulas is also acceptable. > >
|
Pages: 1 Prev: How to remove headers when importing from an external source? Next: SUMPRODUCT and Dates |