Clean up and summarize data
How to total amounts by category without repeating SUMIF formulas
Group repeated categories and calculate their totals and record counts together. Check the overall sum and understand how blank amounts affect the result.
Make spreadsheet work simpler
Match customer lists, find missing values, and combine spreadsheets. See how to solve everyday Excel problems with worked examples in JOIN SHEET.
Clean up and summarize data
How to calculate a weighted average price when quantities differ
Multiply quantity by unit price, sum by product and divide total cost by total quantity. Check why a simple price average can give the wrong answer.