Forum Discussion
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...
- 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.
So, suggested formula shall give correct result. Did you check in the file attached to previous post?
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.
=B41-SUM(B13:B16;B19:B20;B23:B26;B29:B36)
With a ";" not a "," between each table
Thank you so much for your replies.
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.