Aging Count Formula

[Kuppanagari_Pavani]

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

[#2]

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?

[#3]

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.

[#4]

@Kuppanagari_Pavani 

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)

[#5]

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 

[#6]

You may need to provide an anonymized sample workbook that contains this same structure with those sheets.

[#7]

How I need to attach Excel file here .@Patrick2788 

[#8]

If the attachement option is missing, you can share via OneDrive link or another host.