Forum Discussion
Formula to Sum Column referencing another Column based on Criteria
I am trying to sum the values of one column by referencing another column that has repetitive criteria (similar to a Pivot but with a formula instead). For example, in column A "MGMTCO001" is lis...
For dynamic approach you can use BYROW() function. Check the attached file.
=BYROW(A8:A15,LAMBDA(x,SUMIFS(P8:P15,A8:A15,x)))You can also use SUMIFS() function like-
=SUMIFS($P$8:$P$15,$A$8:$A$15,A8)