Formula error - Incorrect argument set

I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is:

=SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30))

My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the last 30 days.

When I wrote the formula for the individual sheet (no cross reference) it worked. The sheet formula is:

=SUMIFS([No of Poles]:[No of Poles], Vendor:Vendor, "ALLO", [Date Received]:[Date Received], >=TODAY(-30))

Thanks!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jgorsich

More than once when entering cross sheet references I've accidentally clicked on the way out of the screen and changed my column reference to a cell reference without being aware of it. Mis-matched range sizes will give that error code and is your most likely cause - I'd start by double checking all of them (possibly to the point of replacing them with new references to make sure).

Paul Newcome

I have also selected a {Range} too quickly after the pop-up window opens but before the reference sheet actually loads in. Once the sheet loads, the selection automatically reverts back to the home cell (top left corner of your sheet), and you have to re-select your range.

Before selecting, make sure the sheet name is in bold immediately underneath of the range name.

Lucinda Bugbee

Thank you both for responding. Unfortunately, neither one of your tips/tricks worked. I took my time re-writing the formula into my sheet and made sure the page was fully loaded. I am still receiving the error. Any other suggestions?

heyjay

Try to delete your reference and create them again. Date columns should have date as properties and anything you reference should be a column.

Paul Newcome

Is that error present in even one referenced cell? Are you clicking on the column header for each reference to select the entire column or selecting a range of cells?

Lucinda Bugbee

Paul… All of the cross references are columns that I have selected and created a reference name for the range. The underlying sheet does not have any errors. Someone mentioned the date column and I have doubled check that it is a date property 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.