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
-
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
-
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))
-
Hi KPH,
Thank you so much! That worked perfectly!
-
Wonderful!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!