CascadeDiver
Board Regular
- Joined
- Apr 10, 2020
- Messages
- 62
- Office Version
- 2016
- Platform
- Windows
Hello,
I'm having a difficult time writing a formula that acts like Index match match along with sumifs.
I have a table with a column of dates and 4 columns with names. To the right of each name column is a number.
My end goal is to sum the numbers adjacent to each name and date. Those numbers are then placed in a different table that has Dates, Names, and Sums.
In the example I have some dates skipped and some dates duplicated. Shown in the right graph is the desired outcome.
I've tried doing a Power Query to achieve these results however I got a bit lost in that attempt.
I'm having a difficult time writing a formula that acts like Index match match along with sumifs.
I have a table with a column of dates and 4 columns with names. To the right of each name column is a number.
My end goal is to sum the numbers adjacent to each name and date. Those numbers are then placed in a different table that has Dates, Names, and Sums.
In the example I have some dates skipped and some dates duplicated. Shown in the right graph is the desired outcome.
I've tried doing a Power Query to achieve these results however I got a bit lost in that attempt.