Forum Discussion

Kuppanagari_Pavani's avatar
Kuppanagari_Pavani
Copper Contributor
Feb 23, 2024

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 tickets combined as well.
Any help would be greatly appreciated.

Excel formula please help

 

 

7 Replies

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        You may need to provide an anonymized sample workbook that contains this same structure with those sheets.
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    I think viewers may be confused by the arrangement of your data at the bottom. What does P1 & P2 include and why are there 4 rows?
    • Kuppanagari_Pavani's avatar
      Kuppanagari_Pavani
      Copper Contributor
      P1 & P2 mean High and Medium tickets above table priority is there as per that we need count 0-7, >15 day , > 30 days how many tickets are there count require.

Resources