how can I get SUMPRODUCT to ignore cells with text

[cjcass]

Hi,
I have the formula below which returns an error if there are any cells with text in the range A7:B7, how can I get the formula to ignore any cells with text?
Thanks

=SUMPRODUCT((A7:BC7)*(--ISNUMBER(MATCH($A$3:$BC$3,Levels!$C$15:$C$26,0))))/COUNTA(Levels!$C$15:$C$26)

 

[pgc01]

Hi

Try replacing the asterisk with a comma.

 

[cjcass]

awesome!
thank you

 

[pgc01]

You're welcome.