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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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}
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome YES! That was the problem. Many thanks for your help!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!