Forum Discussion

AmelieS1025's avatar
AmelieS1025
Copper Contributor
May 24, 2022
Solved

Soustraire la somme de certaines cellules à 1 seule cellule

Bonjour,   Je cherche la solution à un problème, je souhaite soustraire plusieurs cellules à une cellule et je n'y arrive pas.   La syntaxe que j'utilise est la suivante :  =B41-SOMME(B13:B16+B1...
excel
  • AmelieS1025's avatar
    AmelieS1025
    May 25, 2022
    Yes I did, I have finally found the solution it was :

    =B41-SUM(B13:B16;B19:B20;B23:B26;B29:B36)

    With a ";" not a "," between each table

    Thank you so much for your replies.
AmelieS1025's avatar
AmelieS1025
Copper Contributor
May 24, 2022
Bonjour,

Ca ne fonctionne pas comme ça, chaque cellule entre les "+" sont dans des petits tableaux. Et je souhaiterais les relier afin de les soustraire à une valeur inscrite dans un autre tableau.

  • AmelieS1025's avatar
    AmelieS1025
    Copper Contributor
    May 25, 2022

    SergeiBaklan Yes it looks like that, it's just that the cells are in a table each.

     

    Like this

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 25, 2022

      AmelieS1025 

      So, suggested formula shall give correct result. Did you check in the file attached to previous post?

      • AmelieS1025's avatar
        AmelieS1025
        Copper Contributor
        May 25, 2022
        Yes I did, I have finally found the solution it was :

        =B41-SUM(B13:B16;B19:B20;B23:B26;B29:B36)

        With a ";" not a "," between each table

        Thank you so much for your replies.

Resources