Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 1, 2024
Average Based on a Single Criteria
The following formula returns the average for C3:C12, where the corresponding value in B3:B12 equals the value in E3...
=AVERAGEIF(B3:B12,E3,C3:C12)
For earlier versions of Excel...
=AVERAGE(IF(B3:B12=E3,C3:C12))
Note that the formula needs to be confirmed with CTRL+SHIFT+ENTER. If done correctly, Excel will automatically place curly braces {...} around the formula.
Based on the sample data, the formulas return 50.33.
Sample Workbook: Download