a Counting question
 

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

a Counting question
 

=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

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

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

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