Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following:
1) AVERAGE the numerical values in one column.
2) IF the data was collected in a certain month, which is identified in a different column.
So for example, I would like to average all of the October data, November data, December etc.
Any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!