Forum Discussion
KAumjaudAtos
Jan 30, 2019Copper Contributor
Formula in a table : use structures reference vs pointing to a cell
hello, I'm struggling to find my solution :-) I'm using a table, and making calculation in it : A / B / C / D / E / F / G / H / 1 / 2 / 3 / 4... I would like to make a formula doing : ($ mea...
SergeiBaklan
Jan 30, 2019Diamond Contributor
You may use
=[@[A]:[A]]*[@[B]:[B]]*[@1]
KAumjaudAtos
Jan 30, 2019Copper Contributor
**bleep** soo easy :-)
I've been looking for this solution for a long time ! great thanks Sergei !!
- SergeiBaklanJan 30, 2019Diamond Contributor
Each of us constantly finds something new in Excel, it's infinite