subtract one cell from each cell in a range and count instances

[tworrall]

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:E>30

 

[Jacob Skaria]

Try
=SUMPRODUCT((A2-E1:E100>30)*(E1:E100>0))

If this post helps click Yes

 

[Glenn]

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:E>30

=COUNTIF(E:E,"<"&A2-30)