|
SE MN | I have a spreadsheet that I keep track of my contracted crops. In the same sheet I enter in every load that I haul in. When I enter the load, I have a drop down menu that I can select which contract it’s for and then it automatically knows how much I have to haul. I would like it to calculate what I have left to haul to fill that contract. I used to just have the first load reference the contract total and then the following load would just be =(contract load cell- this loads bu.) then the following load would be 2nd load minus 3rd and so forth. This year I am filling 3 different contracts at the same time and would like it to remember what I have left to haul automatically. Is there a way to keep a running total for each contract that updates whenever I haul a new load? | |
|