Combining multiple AVERAGEIF to AVERAGEIFS

Hello,
I am trying to combine the fomulae in column B in the attached to keep a consistent formula in the column. The average should not include values of "0" and should be averaged together by the text in column A.
My thought was something like this:

=AverageIfs(C$1:C$15,C$1:C$15,C:1=

and then I get sort of stuck..


I could also nest IF statements with
IF(C1:15="AA",Averageif(C1:C15>"0",IF((C1:C15="BB",(AverageIf(C1:C15>"0", etc

But that is unwieldy and a little clunky. I am sure there is a way to use AVERAGEIFS, but just don't know how to make it work.

Maybe a table would work better?

Thank you in advance for any help.

Put this in E1 and copy down.

Finds the average for whatever is in Col A excluding rows where Col C is Zero.
Formula for first row is:

=AVERAGEIFS(B$2:B$18,B$2:B$18,">0",A$2:A$18,A2)

Formula for second entry onward checks whether the "average" is the same as the row above. If it is it sets the cell as blank. If it isn't, it finds the Average for the new match in Col A

=IF(AVERAGEIFS(B$2:B$18,B$2:B$18,">0",A$2:A$18,A3)=AVERAGEIFS(B$2:B$18,B$2:B$18,">0",A$2:A$18,A2),"",AVERAGEIFS(B$2:B$18,B$2:B$18,">0",A$2:A$18,A3))

NOTE: Only works if Col A is sorted.

Hope this helps?

Ochimus

Thanks guys, this is a huge help. I can move on to the next road block....Index/Match/Match!!!