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?

Find more posts tagged with

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.