Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
freebee freebee is offline
external usenet poster
  
Posts: 19
Default sumproduct
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.
Reply With QuoteReply With Quote