I am working on a Google Doc spreadsheet using a not-so-simple formula. The formula works but is not as I want it. What I want to achieve is:
"Compare each cell from T3 to AM3 to each cell from T2 to AM2 and give 1 if they match, otherwise 0. Then make a sum of it all.
So if 10 pair of cells match, I should have 10. If 13 match, 13, and so on. If none match, 0.
I thought of writing something like
=SUM(IF(T3:AM3=$T$2:$AM$2;1;0))
But this gives me 1 if they all match and 0 even in the case of one pair not matching. How do I tell the spreadsheet to apply to every pair?
And how can I "sum"? The fact is "sum" won't work without at least two parameters and I don't need a second parameter. I'm at a dead end.