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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!