Thread: Rectify function - combination of Sumproduct and OR
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Rectify function - combination of Sumproduct and OR
Hello,

I suggest
=SUMPRODUCT(--($B$19:$B$24="av"),SIGN(($C$19:$C$24="LADD") + ($C$19:$C
$24="LCH") + ($C$19:$C$24="MSL")),$D$19:$D$24)

Regards,
Bernd
Reply With QuoteReply With Quote