AVERAGEIF COLLECT with multiple criteria from multiple columns

Hello,

What is the best formula to use to incorporate a second column criteria to an AVERAGEIF formula? I tried to use COLLECT in the formula but it's giving me an incorrect argument error.

I tried this but it's giving error.

=ROUND(AVERAGEIF([Site Rec'd:]:[Site Rec'd:], "F05", [Spec Type:]:[Spec Type:], "MS", [Receipt to Test/Spl Plan TAT]:[Receipt to Test/Spl Plan TAT]))

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@jeanniesry_4

See if this works out for you

=AVERAGEIF(AND(Range 1,Criteria 1,Range 2, Criteria 2),[average_range])

jeanniesry_4

Hi @Mark.poole ,

Not sure if I positioned all the criteria correctly but I'm getting #UNPARSEABLE.

heyjay

=AVG(COLLECT(
[Receipt to Test/Spl Plan TAT]:[Receipt to Test/Spl Plan TAT], 
[Site Rec'd:]:[Site Rec'd:], "F05", 
[Spec Type:]:[Spec Type:], "MS"))

Thanks to PaulN -

https://community.smartsheet.com/discussion/65086/averageifs-question

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.