SUMIFS combined with summing values with same value

[thomasuponor]

To be honest I don't know if the headline is correct but it was the best I could come up with.

I have a simple sumifs formula summing L when M="Active" and P=Projects!B114:

=SUMIFS(Quotes!L:L;Quotes!M:M;"Active";Quotes!P:P;Projects!B114)

I want to extend the formula also to look at column F and sum the highest values in L for identical values in F. So (Lemvigh = 11.152 + 9.388 = 20.540) and (Sanistål = 9.955). Therefore the formula should return 20.540.

Any hint here? I am thinking using match formula but not sure how to get started.
Thx
T

 

[Sufiyan97]

To be honest I don't know if the headline is correct but it was the best I could come up with.

I have a simple sumifs formula summing L when M="Active" and P=Projects!B114:

=SUMIFS(Quotes!L:L;Quotes!M:M;"Active";Quotes!P:P;Projects!B114)

View attachment 33565

I want to extend the formula also to look at column F and sum the highest values in L for identical values in F. So (Lemvigh = 11.152 + 9.388 = 20.540) and (Sanistål = 9.955). Therefore the formula should return 20.540.

Any hint here? I am thinking using match formula but not sure how to get started.
Thx
T

Not sure without actual data but you can try

=SUMIFS(Quotes!L:L,Quotes!M:M,"Active",Quotes!P:P,Projects!B114,Quotes!F:F,F2)