I need help in finding a formula to do the following:
- There are three worksheets with monthly fuel data for 11 vehicles. Each vehicles has its own ID. The three worksheets represent three Filling Stations managed by 1 person/filling station. Vehicles get fuel in each of the three filling stations during the month.
- At the end of the month I receive individual fuel reports by each filling station manager. In the Total worksheet I want to calculate the total fuel and cost by each vehicle (ID 11-20). I do not want to copy each worksheet in one, I still want to retain individual worksheets when doing the calculation.
- Is there a formula that I can use in Total worksheet that can calculate the Total Fuel in Gallons and Cost for each Vehicle ID?
I will appreciate any help or advise...
Please see the attached excel file.
Bookmarks