Sum(Sumifs -- not returning as expected

[brendanolear]

Can't understand where this formula is going wrong.

=SUM(SUMIFS(A:A,B:B,{"bob","tim"},C:C,{"North","West"}))

If I amend all entries in col C to west it returns for tim and if I amend all to North it returns for bob.

I need it to return for both bob and tim irrespective if north or west.

 

[Weazel]

try it like....

=SUM(SUMIFS(A:A,B:B,{"bob","tim"},C:C,{"North";"West"}))

 

[brendanolear]

Thanks Weazel works perfectly.