View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default SUMPRODUCT Help Please

whoops ... think the OFFSET wasn't necessary here

This simpler version seems to work just as well:
=SUMPRODUCT(($R$2:$R$7051=R2)*($L$2:$P$7051))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---