Sumproduct and sumif

I am having problems coming up with an alternative to sumif. The following formula works fine but sumif only works if the reference file is open which is why I am looking for a sumproduct solution.

=SUMPRODUCT((SUMIF('[2018-SPENDING.xlsx]Sheet1'!$S$14:$S$50000,$O$47:$O$57,'[2018-SPENDING.xlsx]Sheet1'!$H$14:$H$50000)))

I can brute force it with the following equation which is ok if I only have a few conditions but it isn't practical if I have 20 or 30 conditions.

sumproduct(--((array1=condition1,)+(array1=condition2)+(array1=condition3)etc),sumname)

Any ideas on how to resolve this would be helpful
thanks

I think I uploaded a file. It is a pictorial representation of what I am trying to do

Forget that last post.. the atttachment was wrong. Here is the corrected one.

If anyone is interested, this is the formula I ended up with that works.

SUMPRODUCT(--ISNA(MATCH(name,$O$8:$O$43,0)),sumname)

The ISNA turns the Match into Not Match which is exactly what I was looking for.