SUMIFS referencing another sheet and [column]@row

I'm trying to sort the data exported from Resource Manager into something I can put in my budget. The formula I'm trying is:

=SUMIFS({Import sheet Range 1}:{Import sheet Range 1};

{Import sheet Range 2}:{Import sheet Range 2}; [Fas]@row; {Import sheet Range

3}:{Import sheet Range 3}; [Roll]@row, {Import sheet Range 5}:{Import sheet

Range 5}, [Kategori]@row, {Import sheet Range 4}:{Import sheet Range 4}, [Week

9]1)

My intention is to collect the specific value for each week that correspond to the criteria's in the columns "Fas", "Roll" and "Kategori" on the same row during Week 9 from an import sheet I use to import data exported to Excel from Resource Manager...

I'm open to all suggestions :-). Many thanks in advance.

/Erik

Find more posts tagged with

Accepted answers

Paul Newcome

Double check all of your ranges. Assuming all ranges are supposed to be single column references, make sure you are clicking on the column header for the column you want to reference.

Your syntax is correct, so that should be the only reason for that particular error.

All comments

Paul Newcome

When using a cross sheet reference, you only enter it once for a range.

{Cross Sheet Reference}:{Cross Sheet Reference}

changes to

{Cross Sheet Reference}

Erik_W

@Paul Newcome Thank you som much for your help.

I've taken out all double references and inserted a few $. This has changed the status #INCORRECT ARGUMENT SET... and I can't figure out what's missing... Please help.

=SUMIFS({Import sheet Range 1}; {Import sheet Range 2}; $Fas@row; {Import sheet Range 3}; $Roll@row; {Import sheet Range 5}; $Kategori@row; {Import sheet Range 4}; [Week 9]$1)

Paul Newcome

Double check all of your ranges. Assuming all ranges are supposed to be single column references, make sure you are clicking on the column header for the column you want to reference.

Your syntax is correct, so that should be the only reason for that particular error.

Erik_W

@Paul Newcome YES! That was the problem. Many thanks for your help!

Paul Newcome

Happy to help. 👍️

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.