Running total calculation projection

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

Guest

Hi
I can't figure this one out, please help. I have built a financial data sheet that creates a projection of what the total will be which works ok, but a new entry is added each day that changes it. If the next day is blank is continues to reduce the formula out to the end of the month. I believe a vlookup formula will work but , what do I use for it not to continue to calculate until the blanks are filled?
=m6/a6*A4
where m6 is totals sale
A6 is the number of workdate
a4 is total number of workdays in the mont

Thanks
 
Hi
not really sure what you're trying to do b ut maybe the following is
what you're looking for
=IF(M6<>"",M6/A6*A4,"")
 
You must log in or register to reply here.

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

Copy a formula using Vlookup 2
Removing various combinations of text and returning only a number inexcel 6
How to shift a weekend date to the last or next workday 2
calculation help 5
Help with a pop-up msg 5
Formula Question 2
Formulas only calculate a result when there is matching data in ce 2
Summary of Difference between dates in years, months, days 3

Back
Top