I am banging my head against a brick wall, but i cant for the life of me work out a way to ignore blanks and only take a number as an answer
=SUMPRODUCT(('Group Stage Fixtures'!$B$50:$B$85='Group Stage Results'!B5)*('Group Stage Fixtures'!$C$50:$C$85>'Group Stage Fixtures'!$E$50:$E$85))
its this bit which is blank = Group Stage Fixtures'!$C$50:$C$85>'Group Stage Fixtures'!$E$50:$E$85))
if the cells are blank just return 0
any help would be highly appreciated on this
Many thanks
=SUMPRODUCT(('Group Stage Fixtures'!$B$50:$B$85='Group Stage Results'!B5)*('Group Stage Fixtures'!$C$50:$C$85>'Group Stage Fixtures'!$E$50:$E$85))
its this bit which is blank = Group Stage Fixtures'!$C$50:$C$85>'Group Stage Fixtures'!$E$50:$E$85))
if the cells are blank just return 0
any help would be highly appreciated on this
Many thanks