Two word lookup, one formula?

[J.W. Aldridge]

The following formula works great. The only ammendment I need to make
is to add another word to the third criteria already given.

It needs to lookup "completed" or "done".(The column may say either
one.)

Any suggestions as to the best way to get this accomplished?


=SUMPRODUCT(('Formals Out'!B$6:B$10000=C7)*('Formals Out'!G$6:G$10000=N
$5)*('Formals Out'!D$6$10000="completed"))

Thanx

 

[Bob Phillips]

=SUMPRODUCT(('Formals Out'!B$6:B$10000=C7)
*('Formals Out'!G$6:G$10000=N$5)
*('Formals
Out'!D$6$10000={"completed","done"}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)