View Single Post
  #3  
Old March 19th, 2010, 01:23 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default a Counting question

=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