Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Saro,
If its Text box, try like below
=Sum(Aggr(Above(Sum(C)/ Sum(F),0,RowNo()), A))
Hi
Try like below
Sum( Aggr(RangeSum(Above(Sum(C)/ Sum(F),0,RowNo())), A))
Screenshot:
@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.
Hi Saro,
If its Text box, try like below
=Sum(Aggr(Above(Sum(C)/ Sum(F),0,RowNo()), A))
Thanks bro. Its working