Hi Kathy,

Am Fri, 10 Jan 2014 14:10:07 +0000 schrieb KathyP143:

(B2:B10,"<ok",H2:H10,"=0",G2:G10)

try:
=SUMPRODUCT(--(B2:B10<"ok"),--(H2:H10=0),G2:G10)


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