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

[Guest]

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

 

[Guest]

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

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

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