Thread: a Counting question
View Single Post
  #4  
Old March 19th, 2010, 04:42 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
  
Posts: 2,386
Default a Counting question
Jacob, the OP wants Count, not Sum.

Regards,
Fred

"Jacob Skaria" wrote in message
...
=SUMIF(B5:B1525,"" & A3)

--
Jacob


"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