... I get a 0 instead of the value in column G.
My row 1 was copied from Sheet2 row 1 so I'm positive they do match.

Could be that the nums in col G are text nums
Try an "+0" to col G to coerce it to sum correctly, viz make it:
... ,Sheet2!G$1:$G$10+0)

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---