Ah, I see. This should do it:
=SUMPRODUCT(--($DE$18:$DE$36=U$18:U$36),$DG$18:$DG$36)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote
Not quite; it's still only adds one row.
Please try this test spreadsheet to see what I mean -
http://www.quality-computing.com/test.xls.