Forum Discussion
formules matricielles
Bonjour,
J'utilise les formules matricielles pour faciliter les modifications dans mon tableau.
Dans cet exemple, je peux facilement modifier en 1 seule fois la valeur de la colonne "Identité"
...
I believe the Sum(Offset()) Formula should work as expected without confirming (Ctrl + Shift + Enter) as an array formula. If you want to concatenate a range like you reference try looking at this post from Jon Acampora: https://www.excelcampus.com/keyboard-shortcuts/concatenate-range-of-cells/
or Another technique from Chandoo: https://chandoo.org/wp/2014/01/13/combine-text-values-quick-tip/
or perhaps this post on Jacob Hildebrand's website: http://www.vbaexpress.com/forum/archive/index.php/t-52256.html
I used google translate to help understand your question: