Suproduct formula calculation error

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,094
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!

Code:
=SUMPRODUCT((E5:E84="L")*B5:B84)
Thank you.
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,344
See if this works

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

If it does not work check your data for errors

M.
 

Forum statistics

Threads
1,085,586
Messages
5,384,598
Members
401,913
Latest member
chethan av

Some videos you may like

This Week's Hot Topics

Top