This video shows how to calculate total sales by name in excel using the SUM function and VLOOKUP function in less than 30 seconds.