| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtract one cell from each cell in a range and count instances
I want to subtract a singel cell value from a range of cells. For each cell
in the range I want to count the instances of when that cell minus the single cell is greater than 30. I am subtracting two date to get the number of days between the two. If that is greater than 30 I want to count it. The first date is a single date. I want to subtract that date from each date in a range. If the difference is greater than 30, I count it. The result is the count of date differences that are greater tan 30. So I have a date in A2. I have a range of dates E:E. I want to count each instance that A2-E:E30 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtract one cell from each cell in a range and count instances
Try
=SUMPRODUCT((A2-E1:E10030)*(E1:E1000)) If this post helps click Yes --------------- Jacob Skaria "tworrall" wrote: I want to subtract a singel cell value from a range of cells. For each cell in the range I want to count the instances of when that cell minus the single cell is greater than 30. I am subtracting two date to get the number of days between the two. If that is greater than 30 I want to count it. The first date is a single date. I want to subtract that date from each date in a range. If the difference is greater than 30, I count it. The result is the count of date differences that are greater tan 30. So I have a date in A2. I have a range of dates E:E. I want to count each instance that A2-E:E30 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
subtract one cell from each cell in a range and count instances
tworrall wrote:
I want to subtract a singel cell value from a range of cells. For each cell in the range I want to count the instances of when that cell minus the single cell is greater than 30. I am subtracting two date to get the number of days between the two. If that is greater than 30 I want to count it. The first date is a single date. I want to subtract that date from each date in a range. If the difference is greater than 30, I count it. The result is the count of date differences that are greater tan 30. So I have a date in A2. I have a range of dates E:E. I want to count each instance that A2-E:E30 =COUNTIF(E:E,"<"&A2-30) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
