excel - Google Sheets evaluates only first condition in array in SUMIFS statement -

i found example in excel 1 can use array set or conditions. want in google sheets i'm not sure how. using same syntax doesn't work.

sum(sumifs({})
excel university

report

sales   30,050 => formula: =sum(sumifs($c$18:$c$28,$b$18:$b$28,{"sales-labor","sales-hardware","sales-software"})) cos 21,136  gross profit    8,914  sg&a    2,054  net income  6,860 

data

account amount sales-labor 15,050 sales-hardware  10,779 sales-software  4,221 cos-labor   9,058 cos-hardware    8,172 cos-software    3,906 supplies    256 marketing   1,200 trade shows 200 telephone   299 internet    99 

if pop same values google sheets , same formula marked above, you'll value of first criteria.

source: http://www.excel-university.com/sumifs-with-or/

a simple solution use sumproduct , isnumber(match)

=sumproduct(   $c$18:$c$28,   isnumber(match(     b18:b28,     {"sales-labor","sales-hardware","sales-software"},     0))) 

or sumifs. can make delimiter other empty string avoid clashes.

=arrayformula(sumifs(    c18:c28,     find(b18:b28,         join("",              {"sales-labor","sales-hardware","sales-software"})),     ">0"))