Forum Discussion
Solved
Calculation
Hello I can't create a conditional formula. I want to make an automatic calculation by Exemble: Column B contains only text: Here the word "Contributions". Column D contains numbers I'd like th...
Since your version of Excel is French, you have to use the French name of the function:
=SOMME.SI.ENS(D5:D89; B5:B89; "Cotisations")
or
=SOMME.SI(B5:B89; "Cotisations"; D5:D89)
You can use SUMIF or SUMIFS for this:
=SUMIFS(D:D, B:B, "Contributions")
P.S.: if you use comma as decimal separator, use semicolon instead of comma in the formula:
=SUMIFS(D:D; B:B; "Contributions")
Since your version of Excel is French, you have to use the French name of the function:
=SOMME.SI.ENS(D5:D89; B5:B89; "Cotisations")
or
=SOMME.SI(B5:B89; "Cotisations"; D5:D89)
- Thank you very much for your help
I was missing the if after sum
Best wishes for this festive season and for the years to come.
