| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Cells Within 10 of a Cell Value
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Cells Within 10 of a Cell Value
Look in the help index for SUMIF. You can combine
-- Don Guillett Microsoft MVP Excel SalesAid Software "Missbrooke06" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Cells Within 10 of a Cell Value
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| Count the letters in the cells and sum in another cell | Excel Worksheet Functions | |||
| Count cells based on whether another cell is blank or not | Excel Worksheet Functions | |||
| can i use the color of a cell to count the different colerd cells | Excel Discussion (Misc queries) | |||
| count non empty cells if other cell has certain value | Excel Discussion (Misc queries) | |||
Linear Mode
