Excel Count matches of football scores using =SUM(IF(J3:J23=J37:J57,1,0))
Hi everyone. Id expect the above formula (placed in AA34) to return the number 2. But it doesn't, it returns 19! Way off! I think I'm close, and as you will see from all the different formula combinations, I have been trying everything! Hopefully someone can help me out. Many thanks, Shmerty
This question generated 27 answers. To proceed to the answers, click here.