robinflyer
New Member
- Joined
- Aug 20, 2017
- Messages
- 3
i have a small spread sheet and need a running total. i have managed to do the running total but i need the cell with no data to remain empty...
ie
my running total formula in column 'H' is
=SUM($G$2:G2)
and so on down to row G200 but any cell that remains blank in column 'G' returns data in column 'H' as the last data showing so that if i have 5 entries the running total for the 5th entry is put into the remaining cells in column 'H' down to H200 instead of remaing blank until data is added into the cell in column 'G'
i have tried
=IF(G2<=0," ","=SUM($G$2:G2)")
column G is a monetary column in sterling
ie £ -
but this doesnt work...help
ie
my running total formula in column 'H' is
=SUM($G$2:G2)
and so on down to row G200 but any cell that remains blank in column 'G' returns data in column 'H' as the last data showing so that if i have 5 entries the running total for the 5th entry is put into the remaining cells in column 'H' down to H200 instead of remaing blank until data is added into the cell in column 'G'
i have tried
=IF(G2<=0," ","=SUM($G$2:G2)")
column G is a monetary column in sterling
ie £ -
but this doesnt work...help