Quote:
Originally Posted by Claus Busch
hi,
Am Thu, 5 Sep 2013 13:50:27 +0200 schrieb Claus Busch:
=SUMPRODUCT(--([Book1.xlsx]Tabelle1!$A$2:$A$100=$A2),--([Book1.xlsx]Tabelle1!$B$2:$B$100=B$1))
or in Excel version 2007 or later:
=COUNTIFS([Book1.xlsx]Tabelle1!$A$2:$A$100,$A2,[Book1.xlsx]Tabelle1!$B$2:$B$100,B$1)
sorry I copied the wrong formula.
=COUNTIFS([Book1.xlsx]IUpdateRegularly!$A$2:$A$100,$A2,[Book1.xlsx]IUpdateRegularly!$B$2:$B$100,B$1)
or
=SUMPRODUCT(--([Book1.xlsx]IUpdateRegularly!$A$2:$A$100=$A2),--([Book1.xlsx]IUpdateRegularly!$B$2:$B$100=B$1))
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
I will try your formula. Thanks for the reply Claus B. Cheers