Thank you for the explanation. It helps me to understand and learn more.

Joe

"Max" wrote:

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
---