If you have a sales team, sales data in an Excel file and you want to calculate person-wise and team leader-wise sales amount as a summary report you can use the Sum-if formula to calculate such type of amount in Excel. just watch the below video and learn how can you make a Team Leader Sale & Sales Person Sales chart in Excel easy.
Video Tutorial