Hi,

Am Sat, 18 May 2013 11:03:14 +0100 schrieb Grant0193:

Thanks for that but I get a error;

sorry, I posted the formula in German. Try:
=SUMPRODUCT(--($B$5:$B$100="Yes"),--($C$5:$C$100="S"),$D$5:$D$100)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2