Forum Discussion
Aging Count Formula
Hi I am trying to calculate tickets that are 0-7 days, <15 Days, <30 Days etc... This one is for 30 days, but everything shows as zero, which I know is wrong. I want to calculate the count of all...
I'm still not certain why there are 4 rows at the bottom instead of 1. That aside, try this formula:
=COUNTIFS(Priority,"<>Low",Bucket,"="&category)
If MTD count data is in IM sheet and Raw data is in IPC open ticket for that what formula we need to apply Patrick2788
- You may need to provide an anonymized sample workbook that contains this same structure with those sheets.
How I need to attach Excel file here .Patrick2788
- If the attachement option is missing, you can share via OneDrive link or another host.