Formula for AVG when only specific rows should be calculated

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))
Best Answer
-
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))
Answers
-
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))
-
Thanks as always!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!