I want to find the Maximum of a Sum of 2 Cells in a Line where in Column B is a specific identifying string. On this
A B C D 1 Sx 7 1 2 Sx 3 6 3 Eur 3 5 4 AK1 4 5 5 AK1 4 5
when searching for Sx it should return 9. The search string is specified in a named range of the dimension 1x1 (one cell). I cant figure out a way to do this with the standard Excel functions.