Thread: Can i use a reference inside Countif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Can i use a reference inside Countif
On Thu, 2 Apr 2009 08:13:01 -0700, LAM wrote:

=COUNTIF(AM11:AM19,"<=$B$771")

Try:

=COUNTIF(AM11:AM19,"<=" & $B$771)
--ron
Reply With QuoteReply With Quote