SOLVED

Soustraire la somme de certaines cellules à 1 seule cellule

Copper Contributor

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+B19:B20+B23:B26+B29:B36)

 

Certaines cellules sont fusionnées à d'autres tableaux.

 

Le message d'erreur que j'ai est le suivant : #N/A

 

Comment faire ?

 

Merci d'avance pour les réponses.

7 Replies

@AmelieS1025 

Perhaps you mean

=B41-SUM(B13:B16,B19:B20,B23:B26,B29:B36)
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 

Please check in attached file if that's what you are looking for

image.png

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

 

Like this

 

AmelieS1025_0-1653482643518.png

 

@AmelieS1025 

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

best response confirmed by Grahmfs13 (Microsoft)
Solution
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 

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.

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution
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.

View solution in original post