Multiple SUMIFS criteria with multiple criteria in a column

[Andrew Dustin Limento]

Dear all, I am confused about array in Sumifs formula and after browsing several thread about sumifs, i know we cannot use formula such as =SUM(SUMIFS(E3:E10;B3:B10;B14;C3:C10;{"dog";"cat"};D3:D10;{"male";"female"})) and should replace with sumproduct formula, but what if i still need the first criteria B3:B10;B14 (as a primary key of my database), because using sumproduct we use no reference cell like in vlookup and sumifs.

Hope someone can help me

Thank you for the help

 

[Weazel]

try replacing one of your array constants ";" with ","

=SUM(SUMIFS(E3:E10;B3:B10;B14;C3:C10;{"dog","cat"};D3:D10;{"male";"female"}))

 

[Andrew Dustin Limento]

Wow I don't understand but it works. Well i try to use "," at the first time (as suggested), but it's not working, there is an error message. However when I type "\" it works... Thank you Sir! you the man!