Why do I get #incorrect argument set?
Is there a limit to how many criteria I can use in a sumifs function? I can't figure out where I've gone wrong in my formula. I have double checked the references at least 10 times... 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; {Import sheet Range 6}; $Fas$1; WEEKNUMBER(TODAY() - 30) < [Week 9]$2)
Answers
-
I believe the issue is the last part of the statement where you are evaluating the week number. You are doing it all as a condition instead of listing the range followed by the condition. I'm a little "iffy" on this one because of your absolute references, but try this and see if it fixes the issue.
=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; {Import sheet Range 6}; $Fas$1; [Week 9]$2, WEEKNUMBER(TODAY(-30)) < @cell)
-
Hi Carson,
Thank you for your suggestion. Unfortunately it doesn't seem to work in my sheet.
Perhaps I'm going about this the wrong way. I'm trying to collect data (hours worked in a project) from an import sheet and sum it up depending on project, phase, tasks, roles, etc. As the import sheet will eventually fill up with too much info I came up with a solution to use the week numbers as a criteria in order to "save" the data. That way I can (in my mind) sum data from the last 30 days and erase them from the import sheet after 40...
Maybe there is a smarter way to do this and I'm very open to suggestions :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!