Forum Discussion

melissach's avatar
melissach
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!
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Apr 10, 2024

melissach 

Thank you for adding a sample workbook. You can do this with COUNTIFS or a pivot.

=COUNTIFS(Colour, G3:G5, Flower, H1:M1, Event, H2:M2)

 

  • melissach's avatar
    melissach
    Copper Contributor
    Apr 10, 2024
    Doesn't work on my example...
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Apr 10, 2024

      melissach 

      Are you getting a #NAME? error?

       

      Here's the formula without named items:

      =COUNTIFS(A2:A27,G3:G5,B2:B27,H1:M1,C2:C27,H2:M2)

       

      • melissach's avatar
        melissach
        Copper Contributor
        Apr 10, 2024
        Still doesn't work... It's not a #Name error but a formula error. I've switch the countifs in French for my computer but still doesn't work

Resources