Sumproduct...

[How_Do_I]

Hi,

I'm trying to tidy a few of my formulas up...

AC77 is working and giving me the expected result... Why won't the same formula (AI77) work when I remove the "*" and try to use "," and "--" please?

Excel Workbook
	AC	AD	AE	AF	AG	AH	AI
77	6	4	0				0
Mini Leagues

 

[Haseeb Avarakkan]

Hello,

I think ou missing "--" in front of ISNUMBER(MATCH(....

Try this,

=SUMPRODUCT(--ISNUMBER(MATCH(Home,$T$64:$T$75,0)),--(Away=$T77),--(Away_HT="W"))

 

[How_Do_I]

Yes, you are right, that works! ... Thank you.