Forum Discussion
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 the sum in column D to total only the figures linked to the word "Contributions" in column B.
Could you help me?
Many thanks
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)
