Average Number of Tickets Submitted Per Month Exclude months that do not have a ticket submitted

Kpennington

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!

Paul Newcome

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)

Paul Newcome

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)

Kpennington

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

Paul Newcome

Happy to help. 👍️