#INCORRECT ARGUMENT SET

I can not figure this error out for my SUMIFS function

=SUMIFS({Historical RST Hours Information Range 12}, {Historical RST Hours Information Range 14}, "Late Relief", {Historical RST Hours Information Range 9}, [Week of]@row )

Range 12 is a column of numbers

Range 14 is a column of words Looking to fine only the hours that match the "Late Relief" row hours in the Range 12 column

Range 9 is a column of dates

this set up worked for my CountIfS function but it is not working for my SumIfS function.

Find more posts tagged with

Accepted answers

All comments

Leroy Noriega

It could be the column type in range 9 (Date) affecting the SUMIFS.

ralexanderbbx

Can I pull information from a report rather than having to come from a sheet?

My goal is to auto calculate the data using a formula so im not having to calculate or adjust the formula for every row every week we add data

Leroy Noriega

You should be able to use a report and then use the Summarize tab to SUM the column.

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