Which RangeSum() method is better

[#1]

These two formulas give the same result:

=RangeSum(Above(Sum(Sales),0,RowNo())) 
=RangeSum(Above(TotalSales),Sum(Sales)) 

* TotalSales is a label of expression within this formula

So the question is which method is better and why?

[jagan]

Hi,

Check explanation below

1. =RangeSum(Above(Sum(Sales),0,RowNo()))  - If you are accumulating from top row to current row this method is used
2. =RangeSum(Above(TotalSales),Sum(Sales)) - If you are summing up above row and current row sales

Regards,

Jagan.