Thread: Countif
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
  
Posts: 492
Default Countif
=COUNTIF(A1:G1,"<="&A5)
Regards,
Alan.
"Harry" wrote in message
...
How do I do a Countif of cells A1:G1 to check if they are equal to or less
than the value in cell A5.


TIA
Harry




Reply With QuoteReply With Quote