View Single Post
  #5  
Old March 19th, 2010, 06:08 PM posted to microsoft.public.excel.worksheet.functions
cinnie
external usenet poster
 
Posts: 67
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