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!
Help Article Resources
Check out the Formula Handbook template!