Avg Collect Formula Error

cmseeton

I am attempting to create a formula for a dashboard that pulls data from a sheet and needs to reference the amount of days from Approved to contacted for a specific Agent and by Month. I tried to use several formulas starting with the following:

This pulls back all 0's.

I also tried this formula and got the error #Divide by Zero

I would appreciate any help I could get to understand where my errors are!

Michelle Choate 2

What 0s is it pulling back? From what column? Do you have a screenshot of a sheet you can share that shows the columns you are looking to pull in?