COUNTIFS multiple references to another sheet

ajyk27

This formula gives me an error #INCORRECT ARGUMENT

=COUNTIFS({Total Lot Status Global-AgingInventoryDays}, <>"", {Total Lot Status Global-New Division}, "West", {Total Lot Status Global-SalesStatus}, "Spec")

If I isolate each range and criterion under a simple, COUNTIF formula, then all three criterions work fine. It's just the combination and COUNTIFS that don't work.

Michelle Choate 2

The incorrect argument error usually means there is an issue in your formula syntax, usually a misplaced parenthesis or comma. I find I get errors when there is a " - " in my references. I end up using " | " more and more.