excel-day11-2

lookup浅谈数组

 

 

=SUMIF(B:B,H8,E:E)

=SUMIFS(E:E,B:B,H15,C:C,I15)

 

 

=SUM(($A$2:$A$22=L8)*$E$2:$E$22)

=SUM(($A$2:$A$22=L15)*($B$2:$B$22=M15)*$E$2:$E$22)

 

 

 

=MAX((F5-3500)*$C$4:$C$10-$D$4:$D$10)

 

 

 

=LOOKUP(1,0/($A$2:$A$92=G4),$B$2:$B$92)

 

 

=LOOKUP(1,0/(($A$2:$A$13=I6)*($B$2:$B$13=J6)),$D$2:$D$13)