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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

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
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!