I am so sorry it should have said 3 instead of 2.. but someone else already
gave me an answer.
Thanks you for time!

"Pete_UK" wrote:

I don't understand the logic of displaying 2 when there are 3 direct
matches (c1/c1, f3/f3 and t4/t4).

Please explain.

Pete

On Jan 24, 12:20 am, Araseli
wrote:
I'm trying to put together a formula that will count the number of times the
data in column a matches c.
I need a total column in this case(row 6) should say 2 because text in
columns a & c only match 3 times

Say i have:
a b c d e
1 c1 c1
2 c2 c1
3 f3 f3
4 p2 f3
5 t4 t4
6