Subtotal output in specific row

[BenJones13]

Hello all!

Been stumped on this for a while. Is there a way to write an expression to get subtotals and have their output in specific rows?

I would want the to fill in the blanks for each subtotal but I can't seem to achieve it with the Multi-Row formula tool.

	Column 1	Column 2	Column 3
Expense 1	5	6	4
Expense 2	6	5	3
Expense 3	8	4	2
Total Expenses
Income 1	7	2	1
Income 2	8	3	2
Income 3	9	4	3
Total Income

Thanks!

Ben

[davidskaife]

Hi @BenJones13 

Here is one way of doing it:

[binuacs]

@BenJones13 One way of doing this

[BenJones13]

I like the expression used to group, but what if my expenses and incomes were labelled differently? Is there a way to use multiple strings in the Contains function?

	Column 1	Column 2	Column 3
Sales	5	6	4
Fruit	6	5	3
Snow	8	4	2
Total Expenses
Job	7	2	1
Side	8	3	2
Example 3	2	3	4
Total Income

[binuacs · Accepted solution]

@BenJones13 Another way of doing this with the Tile tool

[BS_THE_ANALYST]

One way:

[BenJones13]

Thanks for help! I managed a little work around but not without the foundations you provided! Much appreciated.