I am trying to calculate the average percentage of a range of values but only for certain dates
I am trying to calculate the average percentage of a range of values but want to include values that are within a specified date range- i.e from 1/1 to 3/31 or before x date or after x date based on information in a specified date column. In this case I have a column for Training Date and a column for Training Completion % and in the parent row I would like to be able to calculate the Average Training Completion % of the child rows but only for the training classes within certain dates or before or after certain dates.
Help Article Resources
Check out the Formula Handbook template!