Using RangeSum??

[prasadmundewadi]

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?

[sunny_talwar · Accepted solution]

Try this

=Sum(TOTAL B) - RangeSum(Above(TOTAL B, 1, RowNo(TOTAL)))