A bit similar to this* (I'm not allowed to post links), 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? Sample file attached**.
I can stack the ranges on top of each other, if it helps.
* excelforum.com/excel-formulas-and-functions/944670-sumproduct-multiple-criteria-in-same-column-and-criteria-not-hard-coded.html
** 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)
g8JGn.png
Thanks!
Bookmarks