Average Ifs - multiple Criteria

[Hudson]

Why is the formula in cell M27 on the first tab failing? Any ideas for a fix?

[Ace_XL]

Since all of column K refers to "Ease of ordering (e.g. fax, phone) process", dont you just need...

=AVERAGEIFS('Data Input'!$K$2:$K$5494,'Data Input'!$K$2:$K$5494,"<>0")

[Ace_XL]

Since all of column K refers to "Ease of ordering (e.g. fax, phone) process", dont you just need...

=AVERAGEIFS('Data Input'!$K$2:$K$5494,'Data Input'!$K$2:$K$5494,"<>0")

[Hudson]

Good point - yes. However, I need the formula to only reference 'Lewis' - sorry for not providing this information at the outset

[Ace_XL]

Try..

=AVERAGEIFS('Data Input'!$K$2:$K$5494,'Data Input'!$F$2:$F$5494,"Lewis",'Data Input'!$K$2:$K$5494,"<>0")

You could input Lewis in a separate cell and use that as a reference too.

To avoid a #Div/0! error in case of no matches enclose in IFERROR. Hence,
=IFERROR(AVERAGEIFS('Data Input'!$K$2:$K$5494,'Data Input'!$F$2:$F$5494,"Lewis",'Data Input'!$K$2:$K$5494,"<>0"),"")