Sum if with 2 conditions

  • Hi! Im wondering how to add second condition:
    '[Faktury kosztowe.xlsm]FAKTURY DT'!$S:$S=D1


    to this function:


    =SUM.IF('[Faktury kosztowe.xlsm]FAKTURY DT'!$D:$D;"*"&C1&"*";'[Faktury kosztowe.xlsm]FAKTURY DT'!$M:$M)


    I cant manage to use sumproduct here.

  • Re: Sum if with 2 conditions


    You need SUMIFS


    e.g.


    [COLOR="#0000FF"]=SUM.IFS('[Faktury kosztowe.xlsm]FAKTURY DT'!$M:$M,'[Faktury kosztowe.xlsm]FAKTURY DT'!$D:$D;"*"&C1&"*";'[Faktury kosztowe.xlsm]FAKTURY DT'!$S:$S.D1)[/COLOR]


    You will need to adjust function name to your language.


    Note: In this function the range to SUM comes first, followed by criteria ranges and criteria.

    Where there is a will there are many ways. Finding one that works for you is the challenge!