Thread: Match 3 Criteria and Return Lowest Numeric Value
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sam518 via OfficeKB.com
 
Posts: n/a
Default Match 3 Criteria and Return Lowest Numeric Value
Hi Steve,

Thank you very much for assistance.

Using the Formula below, I get an unexpected Result of zero.
=SUMPRODUCT((E6:AC6=8)*(E4:AC4=MIN(E4:AC4))*(E5:AC 5 ))

Any suggestions?

Cheers,
Sam

SteveG wrote:
Slight typo.
=SUMPRODUCT((E6:AC6=8)*(E4:AC=MIN(E4:AC4))*(E5:AC 5 ))
Steve


--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote