Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobcPettit[_2_] RobcPettit[_2_] is offline
external usenet poster
 
Posts: 108
Default sumproduct

Hi, could somebody explain why the '-' in
=SUMPRODUCT(-(F2:F14="S"),-(G2:G14<8)), make such a difference. Used
without, which I was doing until Iposted here earlier, doesnt return
the same results.
Regards Robert