Countifs for another tab and with multiple selection

Question

What would be the Google Sheet formula?

In the sheet "Employee View," I want to count the number of times the value "Camilla" is included in Column A in the sheet named 'Projects View.' Column A includes multiple values (e.g., Camilla, Santi, Gaspard) in each cell as I am using data validation with multiple selection in Google Sheets.

=COUNTIF(FLATTEN(SPLIT(FILTER('Projects View'!A:A, 'Projects View'!A:A <> ""), " ")), "Camilla")

Saddles · Accepted Answer · 2025-04-10 16:11:45Z

1

You may try:

=COUNTIF('Projects View'!A:A, "*Camilla*")

This outputs the count of the number of times the value "Camilla" is included in Column A in Sheet name 'Projects View' that uses data validation with multiple selection in Google Sheets.

answered Apr 10 at 16:11

Saddles

1,8162 gold badges10 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Saddles Apr 11 at 21:22

If my answer helped, consider accepting it by clicking the checkmark on the left and upvoting it (if possible). This marks the issue as resolved. For more information, see What should I do when someone answers my question?

Collectives™ on Stack Overflow

Countifs for another tab and with multiple selection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related