What is wrong with this formula please

Bianca Thiel

=COUNTIFS([Player 1]15:[Player 5]53, Name@row, Role15:Role53, Role17)

AKnight

Hey @Bianca Thiel !

Try this:

=COUNTIFS([Player 1]15:[Player 5]53, CONTAINS(Name@row, @cell), Role15:Role53, Role$17)

Paul Newcome

Are you getting an error message or an unexpected count? Are you able to provide more details?

Bianca Thiel

=COUNTIFS([Player 1]15:[Player 5]53, Name@row, [Role15:Role53, Role17])

Gives Me #unparseable

Thanks

Bianca Thiel

@AKnight

Thanks i tried your formula but get error message

#incorrect argument set.

Thanks

AKnight

Hey @Bianca Thiel !

What are your column types for Player, Name, and Role? I also noticed your brackets are different in your follow-up message is your formula using

[Role15:Role53, Role17]

or

Role15:Role53, Role17 (without brackets)?

Bianca Thiel

Players Name - Text

Role = Dropdown

=COUNTIFS([Player 1]15:[Player 5]53, Name@row, Role15:Role53, Role17) = #incorrect argument set

=COUNTIFS([Player 1]15:[Player 5]53, CONTAINS(Name@row, @cell), Role15:Role53, Role$17) = #incorrect argument set.

Thank you so much for helping

Bianca Thiel

@AKnight

Players Name = Text

Role = Dropdown

=COUNTIFS([Player 1]15:[Player 5]53, Name@row, Role15:Role53, Role17) = #incorrect argument set

=COUNTIFS([Player 1]15:[Player 5]53, CONTAINS(Name@row, @cell), Role15:Role53, Role$17) = #incorrect argument set.

Thank you so much for helping

Paul Newcome

Your ranges must be of the same size and shape within a function. Your first range looks like it is 5 columns and your second range is only a single column.

You will need to write out 5 separate COUNTIFS (one for each player column) and then add them together.

=COUNTIFS([Player 1]:[Player 1], ………………………….) + COUNTIFS([Player 2]:[Player 2], ………………………) + …………………………………………………

Bianca Thiel

@Paul Newcome Thanks…. not as straightforward as i thought it would be…