COUNTIFS

Mike Carroll

I know this should be easy but I just can't get it right. Trying to count instances of 2 different values in the same column. There are 6 options within the dropdown in the column but I only want to capture the amount of 2 specific values, "Seller Rep" and "Fee"

Tried every variation I can imagine of this: =COUNTIFS([Listing Type]31:[Listing Type]145, "Seller Rep", or "Fee"])

With quotes, without, but always get #UNPARSEABLE. Maybe wrong formula type?

Anyone able to help? It's slaying me!

Thanks

Mike Wilday

Try this.

=COUNTIFS([Listing Type]31:[Listing Type]145, OR(@cell = "Seller Rep", @cell ="Fee"))

When using the or formula you have to encase the different parameters inside of parenthesis after OR and separate them with a comma. You also have to use the @cell parameter to indicate that as it checks each cell in the range either of those parameters are looked at.

Mike Wilday

Try this.

=COUNTIFS([Listing Type]31:[Listing Type]145, OR(@cell = "Seller Rep", @cell ="Fee"))

When using the or formula you have to encase the different parameters inside of parenthesis after OR and separate them with a comma. You also have to use the @cell parameter to indicate that as it checks each cell in the range either of those parameters are looked at.

Mike Carroll

Awesome! Thank you!