Formula Issue

ToTheMax

Hi all,

I am trying to average the values in a column, 'Defective Quantity', when the value in column 'hide' is an '11' (for month) AND the data in column 'Year' is 2023.

=AVERAGEIF([Defective Quantity]:[Defective Quantity], hide:hide, =11, year:year, =2023)

I am receiving an #UNPARSEABLE error. Any idea what I'm doing wrong?

KPH

Hi there,

AVERAGEIF only allows for one criteria. To have more than one criteria you need to use a combination of AVG and COLLECT. Your formula would be

=AVG(COLLECT([Defective Quantity]:[Defective Quantity], hide:hide, =11, year:year, =2023))

KPH

Hi there,

AVERAGEIF only allows for one criteria. To have more than one criteria you need to use a combination of AVG and COLLECT. Your formula would be

=AVG(COLLECT([Defective Quantity]:[Defective Quantity], hide:hide, =11, year:year, =2023))

ToTheMax

Hi KPH,

Thank you so much! That worked perfectly!

KPH

Wonderful!