Forum Discussion

BFK's avatar
BFK
Copper Contributor
Jul 02, 2025

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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 07, 2025

Perhaps source data looks like

and expected answer

isn't it?

m_tarler's avatar
m_tarler
Bronze Contributor
Jul 07, 2025

well maybe?  I have attached your example data tables with an 'unpivot' and then repivot formulas:

 

  • djclements's avatar
    djclements
    Silver Contributor
    Jul 08, 2025

    GROUPBY on both axes is also a potential option here:

    =LET(
   Nz, LAMBDA(x,IF(ISBLANK(x),"",x)),
   y, TRANSPOSE(VSTACK(Nz(A3:F3),GROUPBY(Nz(A4:A8),B4:F8,SUM,3,0))),
   TRANSPOSE(GROUPBY(TAKE(y,,2),DROP(y,,2),SUM,3,0))
)

Resources