Formula Issue

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?

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    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))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!