Sumproduct multiple ranges with multiple conditions

[lwcorp]

A bit similar to this, I have multiple ranges (in this case complicated Pivot tables) arranged by dates. But not all of them have all dates and not all of them have all columns.
I want to prepare a new table that sums up each dates with each type of column.
Can you help me do it, probably with sumproduct?
I can stack the ranges on top of each other, if it helps.

Thanks!

 

[BrianGGG]

Is this a one-time aggregation, or are you looking to create a process to do this on a regular basis?
It's going to be easier if you can cut/paste the individual tables into a single "monster" source range ...

 

[lwcorp]

It's ongoing. To make it easier, sample file is attached.

 

[lwcorp]

Just to clarify, in the attached sample file, if row 28 (16/12/2018), for example, is done manually, it will look like:
Cell B28: =SUM(B6, F5)
Cell C28: =SUM(G5, K4)
Cell D28: =SUM(C6, H5, L4)

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...multiple-ranges-with-multiple-conditions.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[BrianGGG]

This problem exceeds my abilities. The issue is that there's a variable number of pivot tables and a variable number of columns/dates.

I wasn't able to determine how to refer to an entire column in a pivot table, similar to a regular table e.g. "tablename[columnname]", so array formulas are out of the question for now...