As long as L15:L252 and N15:N252 contain numbers only.

=SUMPRODUCT(--(M15:M252=J158),L15:L252+N15:N252)

--
Biff
Microsoft Excel MVP


"freebee" wrote in message
...
Hi, I have a formula looks like
this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252))
How do I simplify to sum L15:L252 and N15:N252
Thanks.