Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|