Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 1, 2024
Average Based on Multiple Criteria
The following formula returns the average for D3:D12, where the corresponding value in B3:B12 equals the value in F3, and the corresponding value in C3:C12 equals the value in G3...
=AVERAGEIFS(D3:D12,B3:B12,F3,C3:C12,G3)
For earlier versions of Excel...
=AVERAGE(IF(B3:B12=F3,IF(C3:C12=G3,D3:D12)))
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 formula returns 53.67.
Sample Workbook: Download