Excel, find number of times cell is the same as another in the same column for m

Question

Excel, find number of times cell is the same as another in the same column for multiple columns

I am trying to figure out a formula that goes into f3 and f4

if their number in the respective columns matches to that of the top number, the count is 1

b3=b1 so count is 1 + d3=d1 so count is 1, so sum of that is 2 (f3)

figure there's an easier way than manually ttyping all the columns' countif'ss. there will be like 20 columns and 20 people.

thanks for any help!!!.

Excel, find number of times cell is the same as another in the same column for multiple columns I am trying to figure out a formula that goes into f3 and f4 if their number in the respective columns matches to that of the top number, the count is 1 b3=b1 so count is 1 + d3=d1 so count is 1, so sum of that is 2 (f3) figure there's an easier way than manually ttyping all the columns' countif'ss. there will be like 20 columns and 20 people. thanks for any help!!!.

Explanation / Answer

You can put:

=SUMPRODUCT(0+(B$1:D$1=B3:D3))

in F3 and copy down.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.