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 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.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 25, 2022

      AmelieS1025 

      Comma or semicolon depends on your regional settings. It's always better not to copy/paste formula from the post, but from the file - it converts formulae to your locale automatically.

      Anyway, great to know you sorted an issue out.

Resources