Like this...
=SUMPRODUCT(--('relocation capture'!$E:$E="Alvarez, Isabel"),--ISNUMBER(MATCH('relocation capture'!$I:$I,{"Award Escrow","Escrow Network"},0)))
You should avoid using entire columns as range references in the SUMPRODUCT function. Use a smaller specific range.
Bookmarks