Hi,

Am Thu, 11 Sep 2014 09:33:01 +0200 schrieb Claus Busch:

=SUM(IF(Sheet1!A5:A40&Sheet1!B5:B40=$G$1&$H$1,Shee t1!C5:C40-Sheet1!D5:D40))

you can do it also with a Pivot table


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