Remove the last array if you want to count

=SOMPRODUCT((LINKS('nieuwe productie 2006'!G4:G1004;3)="DUO")*('nieuwe
productie 2006'!O4:O1004="afgesloten"))

Regards,

Peo Sjoblom

"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:59c5ad26388b2@uwe...
thanks Bob,

The only thing that i had wrong is the , before the 3 ! In dutch this must
be
a ; ....
Thanks Bob.

Just another question:
If i only want the number of entries instead of the sum of the entries,
how
would i adapt the code?
Thanks,
Pierre


Bob Phillips wrote:
=SOMPRODUCT((LINKS('nieuwe productie 2006'!G4:G1004,3)="DUO")*
('nieuwe productie 2006'!O4:O1004="afgesloten")*('nieuwe productie
2006'!S4:
S1004))

Hi experts,

[quoted text clipped - 12 lines]
Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200601/1