...but apparently not
When I wanted an average AND a sum, for instance, I used to add an average to two different columns (as in your first example), then do a find-and-replace to make the second subtotal into a sum on the required column
Makes me wish I still used subtotalling

Thanks, Susan for more Excel enlightenment (even if it is a decade too late!)

JB