Additional Info


  • Hot Topics

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.

This thread is current as of June 6, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel