| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtract a single cell from range of cells and then count
Hi,
you can copy value in A2 and then highlight the range in column E, paste special then click on subtract. To get the count use formula in F2 or where desired =COUNTIF(E2:E8,"30") "tworrall" wrote: I want to subtrcat a single cell from each value in a range. For each result, if greater tthan 30, I want to count those instances. In other words, I would subtract A2 from E:E (each cell). I want to count each time the result is greater than 30. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract one cell from each cell in a range and count instances | Excel Worksheet Functions | |||
| COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL | Excel Discussion (Misc queries) | |||
| Would like one cell to both count and multiply a range of cells | Excel Worksheet Functions | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| How to count a range of values in a single cell? | Excel Worksheet Functions | |||
Threaded Mode
