tables


Indeed, updated the solution with more detail on the dynamic range method of calculating on pivot table data. For very fancy pivot tables with line breaks, subtotals and in-between headers, you could build up the dynamic array to say start at row 4 but end at a row labelled "Subtotal". –



a) First, we will observe all the tables from 2 to 20 and write 2 times 19 mathematically.