Trying to get an Avg $/Hr with a specific task type, Date range, & assigned to.

=AVG(COLLECT({SOS - $/Hr}, {SOS Task Type}, =[Task Type]7, {SOS Project Closed}, >[Start Range]1, {SOS Project Closed}, <[End Range]1, {SOS Assigned to}, =[Assigned To]2)) Gives #INCORRECT ARGUMENT SET.

Using AVERAGEIF is #UNPARSEABLE

Thanks for any help

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

If that error is not present in any range referenced, double check that your ranges are all single column selections from the same sheet as each other.

Alan Hughes

Not sure what is different today. No change to my statement but it works today when it gave an error yesterday. Any thoughts why? But info is populating as needed.

Paul Newcome

It sounds like maybe there was just some latent data on the back end that was hanging on for longer than it should have.

Glad it is working for you now though.

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.