Help with formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami
 
I copied this formula into the spreadsheet; however, it shows "FALSE" in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional information,
and have the running total continue to update. In order to do that, I have
to format cells that do not have any information in them yet. However, once
I format them w/ the formula, then the data from the previous cells copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,
 
Bob I,

I understand now what you're telling me to do...and the formula works fine
for the data that I already have inputted. I want to format the specific
column for FUTURE data entry, which it won't let me do. Like you said, there
has to be something in the D column in order for the formula to work. I'm
trying to format ahead of anticipated future entries, so that when the user
logs in to input another set of data, that data is automatically calculated
and updated. Is there a way to format the E column cells in
advance...without anything being in the D column right now?
 
Yes, see the change I made to check for greater than 0 in the D cell.
Here it again.

IF(D2>0,D2+E1,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with SUMPRODUCT Formula 10
Excel Subtracting multiple columns from another column 3
Autosum data from 2 columns with Divide function 1
summing two columns of different data 4
Macro to add numbers in a text string 5
Summing negative dollar amounts conditional to dates 4
Help with cummulative totals 3
Excel Excel Formula - IF Function with percentages 1

Back
Top