One guess ..
Try in O37: =SUMIF(DE18:DE36,O18,DG18:DG36)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote in message
ups.com...
Hi all,
Here I am again trying to do things that I don't know how to do.
Here's the formula in O37 - =VLOOKUP(O18,DE18:DG36,3)
Of course this is for row 18 in column O and there are 36 rows.
O37 should sum all the rows, not just row 18.
It's probably some form of =sum and an array, ahh.
Thanks,
Michele