Calculate Average if another Range meets criteria
Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another column that calculates the days past based on end and start dates.
How could I find the average if the Item type is Quarterly?
Help Article Resources
Check out the Formula Handbook template!