Average only the values that match a criterion using AVERAGEIF.
Copy this formula
=AVERAGEIF(A:A, "East", C:C)AVERAGEIF averages cells in the average range only where the criteria range matches. For multiple conditions use AVERAGEIFS, where the average range comes first.
=AVERAGEIFS(C:C, A:A, "East", B:B, ">0")→215Average of East-region rows with a positive value.
Use =AVERAGEIF(C:C, "<>0") to average only non-zero values.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.