CountIFs

Adarian Searcy

Creating a function to count certain states in one function listed below:

=COUNTIFS([Travel State]:[Travel State], OR([Travel State]@cell = "CO", [Travel State]@cell = "TX", [Travel State]@cell = "WA", [Travel State]@cell = "OK", [Travel State]@cell = "NM", [Travel State]@cell = "NE", [Travel State]@cell = "MO", [Travel State]@cell = "MN", [Travel State]@cell = "ID", [Travel State]@cell = "IA"))

However, I receive #Unparsable notification.

Carson Penticuff

Give this a try:

=COUNTIFS([Travel State]:[Travel State], OR(@cell = "CO", @cell = "TX", @cell = "WA", @cell = "OK", @cell = "NM", @cell = "NE", @cell = "MO", @cell = "MN", @cell = "ID", @cell = "IA"))

Carson Penticuff

Give this a try:

=COUNTIFS([Travel State]:[Travel State], OR(@cell = "CO", @cell = "TX", @cell = "WA", @cell = "OK", @cell = "NM", @cell = "NE", @cell = "MO", @cell = "MN", @cell = "ID", @cell = "IA"))

Adarian Searcy

Much appreciated, @Carson Penticuff, this worked.