Get sums of different columns of another table

#1

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:
image

1 Like
#2

SwitchIf is one possible solution.

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

2 Likes
#3

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