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!
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!
Last edited by a moderator: