#DIVIDE BY ZERO Error

Nikki_85

I'm hoping I can get some help with my formula returning the above error.

=AVG(COLLECT({Days to Complete}, {PVPN Total Requests}, ="Closed", {Created Date Range}, <=DATE(2025, 1, 31), {Created Date Range}, >=DATE(2025, 1, 1)))

This is the formula I have created. The Days to complete column is a formula that works out the amount of working days the task has taken to complete and will populate when the PVPN Total Requests column is Closed, which is also a formula based on when the Completion date column is populated.

Can anyone give me some advise to resolve? I want to work out the average no of days to complete the tasks per month.

Ryan Sides

Hi Nikki! Make sure you have rows that actually meet your criteria in the collect. The #DIVIDE BY ZERO Error appears when it has nothing to average.

Nikki_85

Ok fab! I found an empty cell! Thanks for your help!

Ryan Sides

Hi Nikki! Make sure you have rows that actually meet your criteria in the collect. The #DIVIDE BY ZERO Error appears when it has nothing to average.

Nikki_85

Ok fab! I found an empty cell! Thanks for your help!