Thread: Match 3 Criteria and Return Lowest Numeric Value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Match 3 Criteria and Return Lowest Numeric Value

Slight typo.

=SUMPRODUCT((E6:AC6=8)*(E4:AC=MIN(E4:AC4))*(E5:AC5 ))

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=529246

Reply With QuoteReply With Quote