LinkBack URL
About LinkBacks
For cumulative sums use
=IF(P1="","",SUM($P$1:P1)) and drag down, where Column P holds your individual values
The formula will change to
For Row 2 =IF(P1="","",SUM($P$1:P2))
For Row 3 =IF(P1="","",SUM($P$1:P3)) and so on
For cumulative sums use
=IF(P1="","",SUM($P$1:P1)) and drag down, where Column P holds your individual values
The formula will change to
For Row 2 =IF(P1="","",SUM($P$1:P2))
For Row 3 =IF(P1="","",SUM($P$1:P3)) and so on
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks