View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cinnie cinnie is offline
external usenet poster
 
Posts: 12
Default a Counting question

Thanks teethless mama - that what I needed
--
cinnie


"Teethless mama" wrote:

=COUNTIF(B5:B1525,"="&A3)


"cinnie" wrote:

hi to all

I'm sure this is easy, but I'm new to Excel.
I need a function that will COUNT all the numbers in a range (B5:B1525)
equal to or greater than the value in A3. (all values are positive integers)

thanks in advance
--
cinnie