Text edited..
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:
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
Bookmarks