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

T

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
 
G

Glenn

tworrall said:
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
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtract a single cell from range of cells and then count 8
Countif and values greater than zero for a named range 1
need to subtract one cell from each cell in a row 1
Count IF 1
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Conditional Formatting and cloring cells and date calculations 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Count Number of Times Q 5

Top