What is wrong with this formula please

Bianca Thiel · 02/03/25

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

AKnight · 02/03/25

Hey @Bianca Thiel !

Try this:

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

Paul Newcome · 02/03/25

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

Bianca Thiel · 02/03/25

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

Gives Me #unparseable

Thanks

Bianca Thiel · 02/03/25

@AKnight

Thanks i tried your formula but get error message

#incorrect argument set.

Thanks

AKnight · 02/03/25

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 · 02/03/25

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 · 02/03/25

@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 · 02/03/25

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 · 02/03/25

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

Formulas and Functions

Formulas and Functions

What is wrong with this formula please

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Finding if a date falls in a range in a referenced sheet

CountIF contains name from a contact list help needed

Formula for averaging days