How Do I Create Accumulative Totals That Do Not Reverse

[Jordonr]

I am trying to total daily aircraft flight time (minus the hours to
next inspection) into a running accumulative total for the month and
year. Each day the worksheet is cleared and new hours entered.
Unfortunately each time the sheet is cleared, the total flight hours
for the day, month and year disappear with the removed data. My
question is, how do I keep the accumulative total (on the same sheet)
from subtracting the previous data but continue to add to the total
for the month and year, or, how can I configure a total to only add
and not subtract when the data cell are cleared?

Forgive my ignorance, but I am only a government worker who has been
tasked to create this project (with no training in Excel).

Thanks,

Jordon

 

[Jonathan Rynd]

(e-mail address removed) (Jordonr) wrote in @posting.google.com:

I am trying to total daily aircraft flight time (minus the hours to
next inspection) into a running accumulative total for the month and
year. Each day the worksheet is cleared and new hours entered.
Unfortunately each time the sheet is cleared, the total flight hours
for the day, month and year disappear with the removed data. My
question is, how do I keep the accumulative total (on the same sheet)
from subtracting the previous data but continue to add to the total
for the month and year, or, how can I configure a total to only add
and not subtract when the data cell are cleared?

Excel is not the right tool for this task. Access sounds like more what
you're looking for.

 

[Jordonr]

(e-mail address removed) (Jordonr) wrote in @posting.google.com:


Excel is not the right tool for this task. Access sounds like more what
you're looking for.

Thank you for replying to my posted question:

My new questions are, how is Access better at this than Excel, and
what about some kind of formula in Visual Basic in Excel? I have
limited experience with Excel (no experience with Access) but it seem
to me that there must be a way to write a formula in Visual Basic
(whatever that might be) that would allow data to be added and not
returned, sort of like a check valve in plumbing. Any thought on
this would be greatly appreciated. Thanks, Jordon

 

[Jonathan Rynd]

(e-mail address removed) (Jordonr) wrote in

My new questions are, how is Access better at this than Excel, and
what about some kind of formula in Visual Basic in Excel? I have
limited experience with Excel (no experience with Access) but it seem
to me that there must be a way to write a formula in Visual Basic
(whatever that might be) that would allow data to be added and not
returned, sort of like a check valve in plumbing. Any thought on
this would be greatly appreciated. Thanks, Jordon

Access allows you to set up a "form" where you can enter data, and when
you're done entering the data, it is saved into a database and the form is
available for the next input. Then when all necessary data is entered, you
run a report which looks over the data you've entered (subject to any
conditions) and calculates the value you want.

You could do this in excel using VB but it would be reinventing the wheel.