Hi again,

Am Tue, 21 Jun 2016 00:06:17 +0200 schrieb Claus Busch:

try in D2:
=IF(MAX((E5:E8=3)*(T5:T8=TRUE))=1,10,5)

without array:
=IF(SUMPRODUCT(--(E5:E8=3),--(T5:T8=TRUE))=1,10,5)

in Excel version 2013 or newer you can also use:
=IF(COUNTIFS(E5:E8,3,T5:T8,TRUE)=1,10,5)


Regards
Claus B.
--
Windows10
Office 2016