thomasuponor
New Member
- Joined
- Sep 13, 2018
- Messages
- 44
- Office Version
- 2016
- Platform
- Windows
Hi,
I am trying to combine sumifs with multiple partial matches wildcards. Somehow the formula is only returning the value of the first value:
Any tip?
Thx
Thomas
I am trying to combine sumifs with multiple partial matches wildcards. Somehow the formula is only returning the value of the first value:
Excel Formula:
=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