Forum Discussion
Solved
Count number of times two cells match across whole sheet
I have a list of names and then in each subsequent column, their team colour listed (Red/Blue). Each week a new column with the each person's team colour for that week will be added. I am trying to ...
=SUMPRODUCT(ISEVEN(COLUMN(sheet2!A:AA))*(((sheet2!A3:AA3="Red")*(sheet2!A4:AA4="Red"))+((sheet2!A3:AA3="Blue")*(sheet2!A4:AA4="Blue"))))You can try this formula.
Sheet2:
Sheet with the formula that counts times two cells match:
=SUMPRODUCT(ISEVEN(COLUMN(sheet2!A:AA))*(((sheet2!A3:AA3="Red")*(sheet2!A4:AA4="Red"))+((sheet2!A3:AA3="Blue")*(sheet2!A4:AA4="Blue"))))You can try this formula.
Sheet2:
Sheet with the formula that counts times two cells match:
- Thank you!
