Get sums of different columns of another table


The image below shows an example of a table that contains the orders of different customers per month. In the second table I want to create an overview for monthly analysis. Therefore I need the sums of the orders by month in the second table.

Since it is not possible to have different formulas for each cell I can’t figure out how to do this.

Does anybody know a way how to solve this?

What I want to achieve is this:

1 Like

SwitchIf is one possible solution.

I’m interested to know if there’s another way to do this.


This is very similar to this thread - Referencing Column Name from another table

The SwitchIf statement works or you can restructure your table and use Lookups.

1 Like