Showing column total in a row

[#1]

Hi,

I want to show the total of colmun Moving Range (which we can see is equals 14)  in the Total moving range column. I think the formula should be

sum(total [Moving Range])  but for some reason not working. Does anyone know where I am going wrong?

Thank you for your help.

[#2 · Accepted solution]

Hi,

Try this formula:

BOTTOM(RANGESUM(RANGESUM(fabs(above(DataPoint) - DataPoint)), ABOVE(RANGESUM(fabs(above(DataPoint) - DataPoint)), 1, ROWNO())))

tks

[#3]

Ecorrea, your a genius. Thank you so much, works a treat.

Dave

[pat_agen]

hi ecorrea,

not for the first time I see things on this community which I didn't think were possible. Very impressive.

have a good weekend.