Forum Discussion
Sumifs or other solution for both vertical & horizontal criteria
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?
well maybe? I have attached your example data tables with an 'unpivot' and then repivot formulas:
