Formula for AVG when only specific rows should be calculated

Tbech

Hello,

Working on a formula that should average number of days worked but also meets two other specific criteria and does not count any rows that are blank as 0. Below is my formula but not confident is calculating the way I need it to. Thoughts?

=AVG(COLLECT({#Worked}, {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Paul Newcome

That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...

=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Paul Newcome

That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...

=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Tbech

Thanks as always!

Paul Newcome

Happy to help. 👍️