Forum Discussion
Sumifs or other solution for both vertical & horizontal criteria
Hi all, I would like to sum values from a matrix of vertical critiera (e.g. names) and horizontal ones (dates as well as other criteria). I am not sure the sumifs formula can actually do this. So fa...
=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.
Thanks Oliver 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