Hi Dave,

Am Mon, 22 Dec 2014 14:28:12 +0000 schrieb Dave011070:

unfortunately it doesn't work for me but I am hoping if you have a few
minutes you may see what I am trying to do in the attached spreadsheet.

try it with:
=SUM(INDEX(Sheet1!A:CA,MATCH(A16&"-"&B16,Sheet1!A:A,0),))

or look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for your workbook


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional