Thread: greater than less than
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rene Rene is offline
external usenet poster
  
Posts: 74
Default greater than less than
How do I insert (F2:F1050) into the formula? Percentage of numbers between
50 and 100

SUMPRODUCT(--(M2:M10="b"),--(F2:F10<100))/COUNTIF(M2:M10,"b")

Thanks in advance.
Reply With QuoteReply With Quote