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)
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.
I was missing the if after sum
Best wishes for this festive season and for the years to come.
Best wishes to you too!