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
|