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.
: Logs operational costs such as electricity, staff salaries, deliveries, and maintenance. Essential Columns for Your Daily Sales Report petrol pump accounting in excel sheet download