Subtotals/Subaverage

2.85K viewsFormulas and Functions
0

Ok,

If I have a row of data such as

14
16
18
12
12

And I wanted to put a subtotal under the 18, then a total under the final 12, how would I do this? Also, could I do the same with calculating an average? Tks.

Carl

0

Hi Carl,

You will want to utilize Groups and the sum(summary) function in your model.

Groups are added by selecting the items you want to group, then using Insert > Group Items from the menu.

The sum(summary) function allows for sub-totals (and sub-averages) and does not get included in the grand total (or overall average).

Please see attached model for a demonstration. Please feel to post again if you have further questions.

-Mike

Attachments

sumave.model