Running Total using IF function

Question

Do i use an If function to display a running total: J2 (todays total yet to be calculated) will be equal to J1 (yesterdays total) plus I2 (todays new entry) but if I2 shows no entry, then J2 shows nothing as well. I only want J2 to show data when I2>0. This way I can set up my running total formula without all my J cells showing the same total as the day before until the I cells are populated with that days entry. Thank you. I kept getting a circular reference.

Answer 1

You are welcome.

Regards,

Ashish Mathur

Microsoft Excel MVP

www.ashishmathur.com

"2010ExcelUser" wrote in message news:a7461be7-e12d-40f3-bd46-198c7a094fb8...

Thank you for taking the time to respond. When I saw your solution and implemented it, it worked perfectly. I apologize in the delay of my response but I just got back to tackling this again today. I really did spend HOURS trying to figure it out again today!. I think my error was partly due to entering a 0 or >0 or>-1. I studied what you did so I could try and figure out someting like this next time on my own. Thank you so much.

---

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

Answer 2

@2010ExcelUser,

You should mark one or more of the message you received that led you to solving your problem as the "Answer" so that others will know your problem has been resolved.

---

NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.

Answer 3

Perfect! Thank you

Answer 4

Ah, that makes sense. Thank you for your response - I have taken note of it!

Answer 5

Thank you, ben's formula did work ( i was kinda chagrined when i saw what a simple fix it was) but I will make a note of yours in case I encoutner that in a spreadsheet going forward. Thanks again for your time. Appreciate it.