01 Using the SUM Function (6.79 MB) 02 AutoSum for Columns and Rows (8.21 MB) 03 COUNT and COUNTA Functions (7.64 MB) 04 COUNTIF - Price Is above a Threshold (3.75 MB) 05 Adding an Adjustable Threshold and Conditional Formatting (6.8 MB) 06 SUMIF and AVERAGEIF Functions (6.26 MB) 07 Using the SUBTOTAL Function with Filtered Records (6.4 MB) 08 Nested Totals with the Subtotal Button (6 MB) microsoft-excel-summarize-data (569.66 KB)