Clean up and summarize data
How to calculate a weighted average price when quantities differ
Find what you paid per unit when purchase quantities and prices differ. Calculate each product's total cost and divide it by the quantity purchased.
Clean up and summarize data
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.