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
Solved! Go to Solution.
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 |
Thanks for help! I managed a little work around but not without the foundations you provided! Much appreciated.