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...
Dear ExcelAnalytica its actually the other way round - sorry for the misleading explanation.
A-G is actually the target structure and current structure is such:
Jun Jul Jul
Actual Actual Plan
Name 1 5 1 2
Name 1 5 2 1
Name 2 3 2 1
Name 1 2 1 1
Name 3 2 1 3
.....
I.e. I have multiple mentioning of the "name" and simply want to sum by name otherwise same structure
If only names to summarise that could be
=LET(
range, $B$2:$H$7,
data, DROP(range,2),
names, TAKE(data,,1),
values, DROP(data,,1),
result, VSTACK( TAKE(range, 2), GROUPBY(names, values, SUM,0,0) ),
IF(result = "", "", result)
)