SUMIFS Formula not recognising a comma
![David Mason](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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 drag-filling the formula down, then up again, can help to re-fresh 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 drag-filling the formula down, then up again, can help to re-fresh 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
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!