ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Running total in blank cells (https://www.excelbanter.com/excel-worksheet-functions/242135-running-total-blank-cells.html)

RAZielinski

Running total in blank cells
 
I put a formula into a sheet that is suppose to maintain a running total. It
works fine but it shows the last total in all the blank cells where I have
not yet put any numbers in. It is confusing to see the last total to show up
all the way down the column. They should be blank until I make a row entry.
How do I correct that?

Don Guillett

Running total in blank cells
 
As always, post YOUR formula for comments.
probably
=if(a2="","", dddd

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAZielinski" wrote in message
...
I put a formula into a sheet that is suppose to maintain a running total.
It
works fine but it shows the last total in all the blank cells where I have
not yet put any numbers in. It is confusing to see the last total to show
up
all the way down the column. They should be blank until I make a row
entry.
How do I correct that?



RAZielinski

Running total in blank cells
 
ITEM COST BALANCE
37,357.79
LBMMC - Ron 800 36,557.79
GPS Navigator 342.97 36,214.82
Carol 1000 35,214.82
Apple Computer 3080.49 32,134.33
Living Spaces 3184.88 28,949.45
Epson Printer 851.96 28,097.49
Colorectal Surgical 431.97 27,665.52
Curtains 3824 23,841.52
Air Conditioning 17500 6,341.52
Living Spaces 548.75 5,792.77
Dentist 2011 3,781.77
3,781.77
3,781.77
3,781.77


"Don Guillett" wrote:

As always, post YOUR formula for comments.
probably
=if(a2="","", dddd

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAZielinski" wrote in message
...
I put a formula into a sheet that is suppose to maintain a running total.
It
works fine but it shows the last total in all the blank cells where I have
not yet put any numbers in. It is confusing to see the last total to show
up
all the way down the column. They should be blank until I make a row
entry.
How do I correct that?




Don Guillett

Running total in blank cells
 

Sure does help??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAZielinski" wrote in message
...
ITEM COST BALANCE
37,357.79
LBMMC - Ron 800 36,557.79
GPS Navigator 342.97 36,214.82
Carol 1000 35,214.82
Apple Computer 3080.49 32,134.33
Living Spaces 3184.88 28,949.45
Epson Printer 851.96 28,097.49
Colorectal Surgical 431.97 27,665.52
Curtains 3824 23,841.52
Air Conditioning 17500 6,341.52
Living Spaces 548.75 5,792.77
Dentist 2011 3,781.77
3,781.77
3,781.77
3,781.77


"Don Guillett" wrote:

As always, post YOUR formula for comments.
probably
=if(a2="","", dddd

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RAZielinski" wrote in message
...
I put a formula into a sheet that is suppose to maintain a running
total.
It
works fine but it shows the last total in all the blank cells where I
have
not yet put any numbers in. It is confusing to see the last total to
show
up
all the way down the column. They should be blank until I make a row
entry.
How do I correct that?






All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com