Thread: Sumproduct if rank <=5 if not return 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tmirelle tmirelle is offline
external usenet poster
  
Posts: 26
Default Sumproduct if rank <=5 if not return 0
here is the equation I have

=SUMPRODUCT(--('06.07'!$B$1:$B$1000='06.07Analysis'!B$1),--('06.07'!$F$1:$F$1000='06.07Analysis'!$A14))

Now what I would like to do is:

If the above function generates a result that is in the Top 5 of a range
(i.e. ranks between 1 & 5) then display the result to the equation above. If
not then return 0

Reply With QuoteReply With Quote