perhaps:
=E4+FLOOR(SUMPRODUCT(COUNTIFS($F$9:$F$38,CHOOSE({1,2},$T$11,$T$14),$G$9:$G$38,CHOOSE({1,2},$U$11,$U$14))),2)
that said, you might need to elaborate on what "met" means -- in the above this is an exact AND match (T11+U11, T14+U14)...
so, with the values provided in the sample this will return 0 (18)... but, with values of 5.1, 1.4, 0.3, and 1.4 in T11, U11, T14, and U14 respectively you would get +2 (20)
Bookmarks