Thanks Peo.
This works fine...
Pierre
Peo Sjoblom wrote:
Try
=SOMPRODUCT((LEFT('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