>What is the point of having a separate subtotal() function, with parameters to indicate whether I want to apply a sum, average, etc., to the selected range, if there are separate function to sum and average, for instance?
Oh, well, after reading a little more in the help, I see that nested subtotals are omitted. That can obviously be an advantage if there are several levels of subtotals / totals. In some reports I had divided the final total by 2, to offset the subtotals, a little awkward if there is a subtotal() function...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)