SOLVED

# Calculation

Copper Contributor

# 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

5 Replies

# Re: Calculation

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

# Re: Calculation

Thank you very much

It doesn't work!

Do you have another formula?

Many thanks

best response confirmed by TomTom64 (Copper Contributor)
Solution

# Re: Calculation

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)

# Re: Calculation

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.

# Re: Calculation

Best wishes to you too!

1 best response

Accepted Solutions
best response confirmed by TomTom64 (Copper Contributor)
Solution

# Re: Calculation

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)