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

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

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
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!