Subtotals

Hi Graham,

Thank you for your post, welcome to the forum, to generate sub totals you first need to sort your list into relevant sections, ie Years, Items, etc. Once you have sorted your list you can then apply subtotals to your sections, follow these steps to apply either Max (highest), Min (lowest), Average, Count of Entries, or Total value of each section;
Data>Subtotals, select the column to subtotal by, then the type of subtotal value, (see above), which column/s you want to view the subtotal/s of and continue following the steps to complete.

Hope that helped, regards Pete