Thread: CountIf & multiple criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
  
Posts: 1,071
Default CountIf & multiple criteria
Excel XP
The formula =CountIf(A1:A50,"<80") counts the cells that have a value less
than 80. How would I modify this formula to change the criteria to less
than 80 AND more than 50? Thanks for your time. Otto


Reply With QuoteReply With Quote