Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my table
load * inline
[A, B
P,1
Q,2
R,3
S,4
T,5
U,6
V,7
W,8
X,9
Y,10
Z,11];
I want to show a result like this in a table:
A | B | Sum(below(B)) |
P | 1 | 65 |
Q | 2 | 63 |
R | 3 | 60 |
S | 4 | 56 |
T | 5 | 51 |
U | 6 | 45 |
V | 7 | 38 |
W | 8 | 30 |
X | 9 | 21 |
Y | 10 | 11 |
Z | 11 | 0 |
the 3rd column is derived like this:
e.g.
for P (2+3+4....+11)
for Q (3+4+5...+11) etc.
How can I do this?
Try this
=Sum(TOTAL B) - RangeSum(Above(TOTAL B, 1, RowNo(TOTAL)))