hi everyone,

can somoene tell me why my formula is giving me a # value error

in collumn M9 to M16 contains text and blank cells and i can't see what is wrong with my formula.

SUMPRODUCT(--(INDIRECT("'"&$L16&"'!$i$8:$m$8")=$M$15),--(INDIRECT("'"&L16&"'!$i$9:$i$16")=$A16),INDIRECT("'"&$L16&"'!$M$9:$m$16"))

am i missing something

thanks for everyone help