Thread
:
SUMPRODUCT Help Please
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Max
external usenet poster
Posts: 9,221
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
---
Reply With Quote
Max
View Public Profile
Find all posts by Max