Average Number of Tickets Submitted Per Month Exclude months that do not have a ticket submitted
I am trying to create a formula for the average number of tickets per month.
I have created a helper column to identify how many tickets are submitted per month. However, I only want the average to divide by months that have a ticket submitted rather than by 12. How would I go about creating that formula? I was thinking a COUNTIF but I cannot seem to get that one right.
Here is the summary formula I have so far: =SUM([Total Per Month]:[Total Per Month]) COUNTIF([Total Per Month],[Total Per Month] >0)
Thanks in advance!
Best Answer

You would use a range/criteria set in the COUNTIF and divide.
=SUM([Total Per Month]:[Total Per Month]) / COUNTIF([Total Per Month]:[Total Per Month], >0)
Answers

You would use a range/criteria set in the COUNTIF and divide.
=SUM([Total Per Month]:[Total Per Month]) / COUNTIF([Total Per Month]:[Total Per Month], >0)

Thank you! I was getting too in the weeds and totally forgot the division sign.

Help Article Resources
Categories
Check out the Formula Handbook template!