Random Excel tidbit: to assign SUMIF criteria by exclusion use SUMIF([ref],"<>[criteria]",[ref])
SUMIF([ref],"<>[criteria]",[ref])