SumProduct and want to exclude blanks

[LoriMaine]

Hi,
I am using the following formula: =SUMPRODUCT(ISNUMBER(FIND(C11:V11,C$7:V$7))*C$6:V$6)
for grading an exam. It appears to be including the cells left blank. I'm uncertain how to get it to EXCLUDE the blanks.

Any ideas?
Thank you!
Lori

 

[Alex Blakenburg]

How about:

=SUMPRODUCT(ISNUMBER(FIND(C11:V11,C$7:V$7))*C$6:V$6*(C11:V11<>""))

 

[LoriMaine]

Oh my gosh, you are a life saver! THANK YOU SO MUCH!!!!

 

[Alex Blakenburg]

You're welcome. Glad I could help.