Forum Discussion

Copper Contributor

Apr 10, 2024

HELP NEEDED! Formula needed for word matches in three different columns

Hello! Need help with counting how many time three words match in the same line in three different columns. Thank you!

Copper Contributor

Apr 10, 2024

Patrick2788 Sure, here you go! Sorry, had to change my Excel to English.

Gold Contributor

Apr 11, 2024

=COUNTIFS(A2:A27,"blue",B2:B27,"rose",C2:C27,"easter")

This formula works in my sheet. The formula in your screenshot has the wrong syntax of criteria_range and criteria.

Patrick2788
Silver Contributor
Apr 11, 2024
You're welcome!
melissach
Copper Contributor
Apr 11, 2024
Thank you guys so much!!!
Patrick2788
Silver Contributor
Apr 11, 2024
melissach
Add a wildcard:
=COUNTIFS(A2:A27,"*blue*",B2:B27,"rose",C2:C27,"easter")
melissach
Copper Contributor
Apr 11, 2024
Thank you!!!!! It works! 😄 And if I want it to find only part of a value. For example, if the colour was midnight blue and indigo blue but I only wanted to target blue to gather every blue?