Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |