Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a count of number of cells filled in?
Ok, I think this might be easier than some of my other questions :)
What I want is a count of the number of cells in one row that are actually used. So any blank ones will not be counted. For example, If I'm using cells C7 - AO7 but only C7 - AB7 are actually used, I want that number. What formula would I use. I know this is probably Kindergarten, but I don't know how to do it. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a count of number of cells filled in?
OH MY GOSH! I did it myself, nevermind :)
But you folks here were the foundation that allowed me to do it! Thanks everyone!!!!! :D "Meenie" wrote: Ok, I think this might be easier than some of my other questions :) What I want is a count of the number of cells in one row that are actually used. So any blank ones will not be counted. For example, If I'm using cells C7 - AO7 but only C7 - AB7 are actually used, I want that number. What formula would I use. I know this is probably Kindergarten, but I don't know how to do it. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a count of number of cells filled in?
Just do a count
=COUNT(C7:AO7) -- -- -John Please rate when your question is answered to help us and others know what is helpful. "Meenie" wrote in message ... Ok, I think this might be easier than some of my other questions :) What I want is a count of the number of cells in one row that are actually used. So any blank ones will not be counted. For example, If I'm using cells C7 - AO7 but only C7 - AB7 are actually used, I want that number. What formula would I use. I know this is probably Kindergarten, but I don't know how to do it. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a count of number of cells filled in?
Try one of these:
=COUNTA(C7:AO7) This will count all *non-empty* cells. This includes formula blanks. If you only want the count of cells that actually display something: =SUMPRODUCT(--(LEN(C7:AO7)0)) This will not count formula blanks. Biff "Meenie" wrote in message ... Ok, I think this might be easier than some of my other questions :) What I want is a count of the number of cells in one row that are actually used. So any blank ones will not be counted. For example, If I'm using cells C7 - AO7 but only C7 - AB7 are actually used, I want that number. What formula would I use. I know this is probably Kindergarten, but I don't know how to do it. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) | |||
Is there a way to count the number of highlighted cells in a col? | Excel Discussion (Misc queries) | |||
I need formula that will automatically count the filled cells. | Excel Discussion (Misc queries) | |||
Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions |