SUMIFS Formula won't compile

rclerico ✭✭✭
edited 12/09/19 in Formulas and Functions

Hey there community! I have been working on this formula for a few days now and it just won't fly.  I think the "<>Closed" is what is throwing it off?  I have tried all sorts of varieties of syntax (<>"Closed", =2019,="2019",) - and it wont fly.

Here is what I have now.  Please see screen shot as well.

=SUMIFS([$USD - Sales Potential]:[$USD - Sales Potential], 2019, [Estimated PO Year]:[Estimated PO Year], "<>Closed", Status:Status)  --  Error thrown: #INCORRECT ARGUMENT SET

Thanks in advance!

Formula Screenshot.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!