Need Averaging Formula

[geddes_3]

I have 4 columns of data, and need to average values that correspond to certain criteria from the other 3 columns. Attached is an example of my data and the desired output. The averages need to come from non-blank cells from Inputs 1 and 2 that match the criteria from the Name column. NeedAverageFormula.xlsx

[sktneer]

Try these array formulas, remember to confirm them with Ctrl+Shift+Enter

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Same way you can write for other names in col. A.

Hope that helps.

[Jonmo1]

Try

A for Input 1 values
=AVERAGEIFS($D$2:$D$11,$A$2:$A$11,"A",$B$2:$B$11,"<>")

A for Input 2 values
=AVERAGEIFS($D$2:$D$11,$A$2:$A$11,"A",$C$2:$C$11,"<>")

[Fotis1991]

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[geddes_3]

That works great. Thank you!

[Jonmo1]

You're welcome.