Calculation

[TomTom64]

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

[#2]

@TomTom64 

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")

[#3]

@HansVogelaar 

Thank you very much

It doesn't work!

Do you have another formula?

Many thanks

[#4 · Accepted solution]

@TomTom64 

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)

[#5]

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.

[#6]

@TomTom64 

Best wishes to you too!