Suproduct formula calculation error

[asyamonique]

Hello,
Is there anything add to below formula that will avoid the error?
If there are letter at on the target cells(column B) it shows #VALUE!

=SUMPRODUCT((E5:E84="L")*B5:B84)

Thank you.

 

[Marcelo Branco]

See if this works

=SUMPRODUCT(--(E5:E84="L"),B5:B84)

If it does not work check your data for errors

M.

 

[asyamonique]

Thanks it worked