Two word lookup, one formula?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

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:D$10000="completed"))

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

--
HTH

Bob

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