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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!