SUMIFS with multiple partial matches

[thomasuponor]

Hi,
I am trying to combine sumifs with multiple partial matches wildcards. Somehow the formula is only returning the value of the first value:

=SUMIFS(Quotes!L:L;Quotes!P:P;Projects!B114;Quotes!M:M;"Active";Quotes!F:F;{"*Brødrene Dahl A/S*";"*Brødrene A. & O. Johansen A/S*";"*Lemvigh-Müller*";"*Sanistål*";"*Solar*";"*Boldsen*";"*Brødrene Kier*";"*DJ Supply*";"*Tengi Ehf*";"*Svend Krosstein*";"*P/F KJ Kambsdalur*";"*P/F Klaksvíkar*";"*P. Hatten*"})

Any tip?
Thx
Thomas

 

[Marcelo Branco]

Try

=SUM(SUMIFS(......))

M.

 

[thomasuponor]

Try

=SUM(SUMIFS(......))

M.

OFC! that will do it
Thx

 

[Marcelo Branco]

You're welcome.

M.