SUMIFS Formula not recognising a comma
Hi
I wonder if anyone is having this problem or if this is user error, When creating a SUMIFS formula the first part apprears fine with the range and criteria range followed by criteria. However, when i enter the comma for the second criteria range and criteria I get an error. the following is my my formula which I think is fairly straight forward. When I hover over the ({ResourceTracker Company}) it appears that system is not picking up the commas and it is highlighted as all one criteria range with no criteria selected. it is as though I have not added the last comma. (I hope that makes sense).
=SUMIFS({ResourceTracker Planned}, {ResourceTracker Month}, "October 2020", {ResourceTracker Company}, Company@row)
I hope some one could explain what I am doing wrong? Any guidance is appreciated. The error I get is #INCORRECT ARGUMENT SET
Best Answers

I have managed to get this working, it seems the hover over function still shows as though the commas have not been recognised but the formula is working!!

Hi @David Mason
Your formula structure looks correct, so I'm glad it worked for you! I've found that sometimes dragfilling the formula down, then up again, can help to refresh it and get rid of an error.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
thank you for the tip, I will definitely keep that in mind. I am a total beginner when it comes to formula.
Thanks
David
Answers

I have managed to get this working, it seems the hover over function still shows as though the commas have not been recognised but the formula is working!!

Hi @David Mason
Your formula structure looks correct, so I'm glad it worked for you! I've found that sometimes dragfilling the formula down, then up again, can help to refresh it and get rid of an error.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
thank you for the tip, I will definitely keep that in mind. I am a total beginner when it comes to formula.
Thanks
David
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!