SUMIF double counting

  • Hi all,


    I am having a problem with a double counting sumif, because of and array.

    ExpertisesOB
    Banking / Finance, PR / Communicatie, HRM / Recruitment, IT / ICT, Management, Marketing / Product Management, SalesOB
    JuridischOB
    IT / ICT, Marketing / Product Management, SalesOB



    I want to count up all the numbers of the expertises Banking / Juridisch /Communicatie. I created the following formula:


    =ArrayFormula(SUM(SUM.If(A2:A4;{"*Banking*";"*Communicatie*";"*Juridisch*"};C2:C4)))


    But it double counts the first row. Is it possible to only count a row once? The outcome in this case was 649, instead of the intended 427.


    Hope someone knows a way of doing this! Looking forward to hearing any solutions.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!