easier way to sumif

[chriswrcg]

I have a data grouping that I need to calculate the total sum. There is multiple criteria to consider, and although I have found a way to do the calculation, there has to be a simpler way.

The criteria includes a date column, number column, and a column that contains multiple two letter codes. The solution I found Is in cell L3 but it is very convoluted and unnecessarily long. A quick solution to the two letter codes in multiple match issue is in L4 but it does not take into account the date and number code criteria. How can I combine the solution in L4 with the other two criteria in a simpler way?

[JohnTopley]

Try

=SUMPRODUCT(SUMIFS($D$1:$D$10,$A$1:$A$10,$L$1,$E$1:$E$10,$M$1,$C$1:$C$10,$H$1:$K$1))

[nick.williams]

One option:

=SUM(IF(C1:C10=H1:K1,IF((A1:A10=L1)*(E1:E10=M1),D1:D10,0),0))

[wk9128]

Cell L3 formula

=SUM(SUMIFS(D:D,A:A,L1,E:E,M1,C:C,H1:K1))

OR

=SUMPRODUCT((A1:A10=L1)*(E1:E10=M1)*(C1:C10=H1:K1)*D1:D10)

[oeldere]

Maybe with a pivot table.

See the attached file.

[wk9128]

@chriswrcg You're Welcome. Glad to help . Thank You for the feedback and rep.