# 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)

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!