On Oct 15, 7:43 pm, "Max" wrote:
Ah, I see. This should do it:
=SUMPRODUCT(--($DE$18:$DE$36=U$18:U$36),$DG$18:$DG$36)
--
Max
Singaporehttp://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.- Hide quoted text -
- Show quoted text -
Perfect. Rocket science to me when you get into that double dash.
Thanks!!