SUMIFS Formula not recognising a comma

David Mason · 03/04/21

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

David Mason · 03/04/21

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!!

Genevieve P. · 03/05/21

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

David Mason · 03/05/21

@Genevieve P

thank you for the tip, I will definitely keep that in mind. I am a total beginner when it comes to formula.

Thanks

David

David Mason · 03/04/21