Expression inside Rangesum

[Saro_2306]

Hi all,

Hope all are doing good, I have small problem in using Rangesum function. My table is like below. I need to perform addition of (A/B) / (D/E)  values. I need to show answer as 10 but while using rangesum function it gives output as 2.148

Formula used : =RangeSum(above(SUM(C),0,RowNo())) / RangeSum(ABOVE(SUM(F),0,RowNo()))

Can anybody helps me to perform above calculation. Thanks in advance

A	B	A/B as C	D	E	D/E as C	(A/B) / (D/E)
100	2	50	50	2	25	2
200	5	40	100	10	10	4
300	3	100	200	4	50	2
400	4	100	150	3	50	2

[MayilVahanan]

Hi 

Try like below

Sum( Aggr(RangeSum(Above(Sum(C)/ Sum(F),0,RowNo())), A))

Screenshot:

[Saro_2306]

@MayilVahanan  Thanks for concern. I need to show sum value is Text box not inside table. your formula works inside table not in Textbox. it shows 26.

[MayilVahanan · Accepted solution]

Hi Saro,

If its Text box, try like below

=Sum(Aggr(Above(Sum(C)/ Sum(F),0,RowNo()), A))

[Saro_2306]

Thanks bro. Its working