excluding zeros from an average if formula

[Cazoline]

I am already using averageif and need to exclude zeros from the formula, see formula as current.
=AVERAGEIF('DOWNLOAD 1'!$Q:$Q,D465,'DOWNLOAD 1'!Y:Y)

I need to exclude the zeros in 'DOWNLOAD 1'!Y:Y from the averageif

Please help

Cazoline

 

[barry houdini]

Hello Cazoline, welcome to MrExcel

Try using AVERAGEIFS (with an "S") like this

=AVERAGEIFS('DOWNLOAD 1'!Y:Y,'DOWNLOAD 1'!$Q:$Q,D465,'DOWNLOAD 1'!Y:Y,"<>0")

 

[Cazoline]

Thank you that is perfect I didn't know you could have multiple ifs