Hi Gurus.
I have a sheet on which the data is like below. Date - Age (Formula ABS(TODAY()-A1) - Priority - Status. I want the report in other sheet that, the total count if any incident is less than or equals to 7 days and is in Status "In Progress" or "Assigned" or "Pending". It should not calculate "Resolved" and those which are old than 7 days.
I have a sheet on which the data is like below. Date - Age (Formula ABS(TODAY()-A1) - Priority - Status. I want the report in other sheet that, the total count if any incident is less than or equals to 7 days and is in Status "In Progress" or "Assigned" or "Pending". It should not calculate "Resolved" and those which are old than 7 days.
Incident 1 | 8/27/2014 | 9 | Low | In progress |
Incident 2 | 9/2/2014 | 3 | High | Pending |
Incident 3 | 8/28/2014 | 7 | Medium | Assigned |
Incident 4 | 8/29/2014 | 7 | Low | Resolved |