Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif or Sumproduct
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif or Sumproduct
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. "Wilson" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif or Sumproduct
Give us a few cell and sheet references to work with - it's easier to
visualise. Pete On May 15, 3:39*pm, Wilson wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct or countif | Excel Discussion (Misc queries) | |||
Sumproduct and Countif together | Excel Discussion (Misc queries) | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
Sumproduct or Countif | Excel Worksheet Functions |