Prev: How to check if the values in a range of cells are greater than 0
Next: how do i create a formula to give a workday date?
From: cinnie on 19 Mar 2010 09:00
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
From: Jacob Skaria on 19 Mar 2010 09:11
=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
From: Teethless mama on 19 Mar 2010 09:23
=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
From: Fred Smith on 19 Mar 2010 12:42
Jacob, the OP wants Count, not Sum.

Regards,
Fred

"Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message
news:AB018290-014F-47DB-8393-2624D2B09151(a)microsoft.com...
> =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

From: cinnie on 19 Mar 2010 14:08
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
 | 
Pages: 1
Prev: How to check if the values in a range of cells are greater than 0
Next: how do i create a formula to give a workday date?