Ok....this is my problem.... have multiple criteria that I need to set up a
SUMPRODUCT function for, equalling some and not equalling some. This is one
example:
Range names: sheet2-ADMDAY,ADMFIN,ADMHSV
formula example for range names:
ADMDAY =OFFSET(sheet2!$B$2,0,0,COUNTA(sheet2!$B:$B),1)

What I need:
Sheet 1, cell E4 ADMDAY=E3, ADMFIN="M" AND "MG", ADMHSV not = "NUR"

My formula:
=SUMPRODUCT((sheet2!ADMFIN="B")*(SHEET2!ADMDAY=SHE ET1!E$3)*(ISNA(MATCH(sheet2!ADMHSV,{"NUR"},0))))

hoping someone can help me, have tried doing the sumproduct seperated, but
then ran into a problem when I didn't want to include those with NUR.