running total blank entry

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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
did you try
=IF(G2="","",SUM($G$2:G2))
 
Upvote 0
so maybe near to what you supplied

=IF(G2<=0,"",SUM($G$2:G2))
 
Upvote 0
perfect thought id tried that but obviously didnt....
however there is one tiny error which doesnt affect the calculation but i would just like to get rid of it but if ness ill live with it

in column 'H' i get a error warning in the corner. the states "this formula omits adjacent cells" ... the formula is the one youve just given me.. column "H" is the running total results for column D which is just a numerical financial number which is the initial figure unlike columns K & M which are the results of sums for vat calculations etc ..

the running total results for vat and vat included are perfectly fine...

i tried to copy and paste a screen shot but it wouldnt and i dont know how to add url pictures



otherwise brilliant thank you so much
 
Upvote 0
I think what you are seeing is just the error comment, which you can choose to ignore which in VBA should be > Application.ErrorCheckingOptions.OmittedCells = False
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top