SUMIFS referencing another sheet and [column]@row
Hi
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
Best Answer
-
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.
Answers
-
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}
-
@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)
-
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.
-
@Paul Newcome YES! That was the problem. Many thanks for your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!