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

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

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

Hi!

Try this:

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

Biff

"Vick" wrote in message
...
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

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

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" wrote in message
...
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

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

You're welcome. Thanks for the feedback!

Biff

"Vick" wrote in message
...
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" wrote in message
...
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