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 [IMG]http://www.liamsmart.co.uk/images/WorldCup2014.jpg[/IMG]


This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of June 06, 2014.


For more resources for Microsoft Excel