Addition with multiple criteria within the same column

Solved
Chti_perdue Posted messages 9 Status Member -  
Chti_perdue Posted messages 9 Status Member -
Hello,
I would like to sum my invoices (column E) regarding certain suppliers (column A), something like:
SUMIF(A1:A100; "Supplier1" or "Supplier2" or "Supplier3"; E1:E100)
But I haven't found out how to replace my "or" function...
Thank you for your help.

8 answers

  1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    it's not easy with OR...
    you can simply write:

    =SUMIF(range, criteria1;...)¨SUMIF(range;criteria2;...) etc...

    or

    =SUMPRODUCT(((range.criteria=criteria1)+(range.criteria="criteria2")+(range.criteria=criteria3))*(range.amount))

    pay attention to the parentheses

    best regards

    To err is human, to persist is diabolical.
    1