Use SUMIFS for conditional totals (e.g., SUMIFS(SalesAmount, DateRange, =Date, ProductRange, "Diesel")). Use XLOOKUP or INDEX/MATCH to fetch product rates or pump mapping.
A "proper" petrol pump spreadsheet should include several interconnected modules: Interactive Dashboard: petrol pump accounting in excel sheet download
Monitors fuel tank levels by comparing opening stock, receipts (deliveries), and sales. Expense Log: Use SUMIFS for conditional totals (e