Countif or Sumproduct

  • Thread starter Thread starter Wilson
  • Start date Start date
W

Wilson

Can someone help write a formula that will provide a count total for a range
of cells where the value (xx/xx/xx) is within plus or minus 5 business days
of a date in the corresponding cell of another column.
 
Try this:

First put a formula in each row to determine if the date is within plus or
minus 5 business days. Something similar to, assuming your date value
(xx/xx/xx) is in cell Column C2 and your corresponding cell is in H8:

=If(ABS(C2-H8)<=5,1,0)

Then do a sum of this new column to arrive at the count of the number of
rows that meet the criteria.

I hope this helped.

Good Luck.
 
Back
Top