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