Average Index Match formula to exclude 0s

[Mariyka1]

Hello,

I have an Average Index Match formula to get the average from a multiple columns. Here's what the formula looks right now and ids working fine - although I noticed I have some 0's in the data and need to exclude this from the average - how would I add it to this formula?

=IFERROR(AVERAGE(INDEX(ALLCOMPS!N:Y,MATCH('SFDC Report'!B2,ALLCOMPS!B:B,0),0)),"")

your help is much appreciated!

 

[FormR]

Hi, you can try AVERAGEIF() - for example:

=IFERROR(AVERAGEIF(INDEX(ALLCOMPS!N:Y,MATCH('SFDC Report'!B2,ALLCOMPS!B:B,0),0),"<>0"),"")

 

[Mariyka1]

This worked out perfectly! thank you !