How many ranges/criteria can I use in a COUNTIFS formula?
I need to look up multiple criteria under the same column with different spelling (like "In Process", INPROCESS, InProcess" and look up on the same sheet but different column a type (like store type).
The different Countifs I've tried either gives me a zero or unparseable, so I am stuck - Help!
Help Article Resources
Check out the Formula Handbook template!