Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to make counters in excel?
I am making an inventory sheet in excel for tracking Fuel pumped into planes. My truck holds 3000 and my tank holds 17000. I would like a excel to add up the totals from each time I fill a plane and subtract that from the truck and then when I refill the truck I would like to have a column setup to put an x in and that would reset the truck to 3000. The point being I can always see how much is in my truck and how much I used that month in fuel. Is this possible?
2 Answers
- fathermartin121Lv 68 years ago
Yes - good question
Heading starting with A1: Invoice | Tank | Truck Fill | Plane | Truck Res. || Total for Month | Tank Res.
B2 Start | 17000
G2 =Sum(D3:D100) ie total of Plane.
I2 =B2-Sum(C3:C100) ie Tank-Truck fill
A3 enter Invoice number to start a new job.
B3 =IF(C3>0,B2-C3,"") as you fill the truck,tank is reduced, otherwise its blank.
C3 enter truck capacity 3000
D3 enter the amount of fuel used in the plane
E3 =C3-D3
B4 =IF(C4>0,B3-C4,"") ie If there is an invoice the tank is reduced by the last plane fill, otherwise blank.
C4 =IF(A4>0,D3,"") ie once there is an invoice raised fill the truck with the last plane fill, otherwise blank. You could replace with a lesser amount if you need to.
E4 =if(C4>0,E3+C4-D4,"") This adds the last truck reserve to the truck fill should be 3000 until plane is entered, other wise blank.
Copy the lowest formuls down the colums to Row 100.
You should only need to enter data into Invoice and Plane, so you might consider protecting the other columns. Rather than invoice number you might want to use the particulars of the plane or customer.
If you do fill the truck to less than capacity, you will have to add more in the subsequent fill, to return to the 3000 truck limit.
Enjoy.
- ?Lv 45 years ago
To set password: Open the file. Go to File>keep As Then a popup reveal will appear. Click tools>common choices. There u can furnish the password to open/modify. Then keep the file.
