Aging Count count

• Kuppanagari_Pavani 

Sure, I can help you with the formula to count tickets based on ticket type, priority, and aging bucket. Here's the formula assuming your data is in the following layout:

• Column A: Ticket Type
• Column B: Priority
• Column C: Age (in days)

=SUMPRODUCT((A2:A$10=A2)*(B2:B$10=B2)*(C2:C$10>=C$2)*(C2:C$10<C$3))

Explanation:

1. SUMPRODUCT: This function multiplies corresponding elements in multiple arrays and returns the sum of those products.
2. A2:A$10=A2: This compares the values in column A from row 2 to 10 with the value in cell A2. It returns an array of TRUE and FALSE values.
3. B2:B$10=B2: Similar to the previous step, this compares the values in column B with the value in cell B2.
4. C2:C$10>=C$2: This compares the values in column C with the value in cell C2 (assuming this is the lower bound of the first aging bucket). It returns an array of TRUE and FALSE values.
5. C2:C$10<C$3: This compares the values in column C with the value in cell C3 (assuming this is the upper bound of the first aging bucket). It returns an array of TRUE and FALSE values.
6. *: The multiplication operator applies element-wise multiplication between the arrays.
7. SUMPRODUCT: Finally, SUMPRODUCT sums the products of the corresponding elements in the arrays, resulting in the count of tickets that meet the specified criteria.

Adjusting the Formula:

• Replace A2:A$10, B2:B$10, and C2:C$10 with the actual ranges of your data.
• Modify C$2 and C$3 to represent the lower and upper bounds of your desired aging buckets. You can add more comparisons within the SUMPRODUCT function to create additional aging buckets.

Example:

Assuming you have the following data:

=SUMPRODUCT((A2:A$3="Support")*(B2:B$3="High")*(C2:C$3>=5)*(C2:C$3<15))

This formula would return 1, indicating one ticket meets the criteria.

Remember to adapt the formula based on your specific data and desired criteria

Can you please explain what exactly you want or DM for further assistance. Kuppanagari_Pavani