J2
=İNDİS($D$1:$D$50;KAÇINCI(1;--(H2=$A$1:$A$50)*--(I2=$B$1:$B$50)*--($C$1:$C$50="AÇIK");0);1)
K2=İNDİS($D$1:$D$50;KAÇINCI(1;--(H2=$A$1:$A$50)*--(I2=$B$1:$B$50)*--($C$1:$C$50="KAPALI");0);1)
=İNDİS($D$1:$D$50;KAÇINCI(1;--(H2=$A$1:$A$50)*--(I2=$B$1:$B$50)*--($C$1:$C$50="AÇIK");0);1)
K2=İNDİS($D$1:$D$50;KAÇINCI(1;--(H2=$A$1:$A$50)*--(I2=$B$1:$B$50)*--($C$1:$C$50="KAPALI");0);1)