Forum Discussion
Sumifs or other solution for both vertical & horizontal criteria
=SUMIFS($L$1:$L$22,$K$1:$K$22,$A3,$J$1:$J$22,B$2,$I$1:$I$22,B$1)This formula is in cell B3 and filled across range B3:F6 in my sample sheet.
Alternatively you can use the relatively new PIVOTBY()
=PIVOTBY(K1:K22,I1:J22,L1:L22,SUM,,0,,0)see attached
Thanks M for your explanation. I realised, I missed to explain, that the data is currently in the matrix and I want it in the following structure, but summed up, since currently (also in the matrix, there is double mentioning of names and dates possible (for the latter I hence also have the "plan"):
Jun 25 Jul 25 ......
Name 1
Name 2
Name 3
I'm sorry but I don't understand what else you need. Both Oliver and I provided solutions in the format where it summed the values for each combination. maybe provide a sample sheet of data and show how it should be summed/tabulated. if you can post here you can share it via cloud service like onedrive or google
Perhaps source data looks like
and expected answer
isn't it?
