SUMIFS Formula won't compile
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!