count each cell that have a number and take that number and count.

[Vick]

I need to take a row and count each cell with a number that equal to and/or
greater than 1. Each cell is counted as 1 and arrive at a total number. If
that number equals to or greater than 3 then count as 1

I used the =COUNTIF(a7:a10) which gives the number of cells with a number
but don't know how to get it to add and if it equal to 3 or more to count as 1

[Biff]

Hi!

Try this:

=IF(COUNTIF(A7:A10,">0")>2,1,COUNTIF(A7:A10,">0"))

Biff

"Vick" <[email protected]> wrote in message
news:[email protected]...
>I need to take a row and count each cell with a number that equal to and/or
> greater than 1. Each cell is counted as 1 and arrive at a total number.
> If
> that number equals to or greater than 3 then count as 1
>
> I used the =COUNTIF(a7:a10) which gives the number of cells with a number
> but don't know how to get it to add and if it equal to 3 or more to count
> as 1

[Vick]

Thank you, Thank you, Thank you! It works beautifully.

"Biff" wrote:

> Hi!
>
> Try this:
>
> =IF(COUNTIF(A7:A10,">0")>2,1,COUNTIF(A7:A10,">0"))
>
> Biff
>
> "Vick" <[email protected]> wrote in message
> news:[email protected]...
> >I need to take a row and count each cell with a number that equal to and/or
> > greater than 1. Each cell is counted as 1 and arrive at a total number.
> > If
> > that number equals to or greater than 3 then count as 1
> >
> > I used the =COUNTIF(a7:a10) which gives the number of cells with a number
> > but don't know how to get it to add and if it equal to 3 or more to count
> > as 1
>
>
>

[Biff]

You're welcome. Thanks for the feedback!

Biff

"Vick" <[email protected]> wrote in message
news:[email protected]...
> Thank you, Thank you, Thank you! It works beautifully.
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> =IF(COUNTIF(A7:A10,">0")>2,1,COUNTIF(A7:A10,">0"))
>>
>> Biff
>>
>> "Vick" <[email protected]> wrote in message
>> news:[email protected]...
>> >I need to take a row and count each cell with a number that equal to
>> >and/or
>> > greater than 1. Each cell is counted as 1 and arrive at a total
>> > number.
>> > If
>> > that number equals to or greater than 3 then count as 1
>> >
>> > I used the =COUNTIF(a7:a10) which gives the number of cells with a
>> > number
>> > but don't know how to get it to add and if it equal to 3 or more to
>> > count
>> > as 1
>>
>>
>>