Hi

I have an AVERAGEIFS formula with multiple criteria that I cannot get to work:

=IFERROR(AVERAGEIFS(Output!$R$26:$R$31876, Output!$U$26:$U$31876,1,Output!$D$26:$D$31876,"WIN",Output!$AL$26:$AL$31876,A10,Output!$AK$26:$AK$31876,"GOOD*",Output!$AK$26:$AK$31876,"DEAD",Output!$AK$26:$AK$31876,"DEAD4"),"No Data")
The "OR" criteria includes "GOOD*" (which includes multiple "GOOD" criteria) and then I need to also include "DEAD" and "DEAD4". I cannot use "DEAD*" as I need to include other versions of "DEAD" in a different formula.

Does anyone know how I can achieve this?