| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I make an equation to count how many cells are filled below acertain cell?
would like the top cell to automatically tell me how many cells below
it have text. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I make an equation to count how many cells are filled below acertain cell?
On Apr 2, 4:01*pm, V L wrote:
would like the top cell to automatically tell me how many cells below it have text. EXCEL 2007 =COUNTA - will count the number of cells in a range that are not empty. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I make an equation to count how many cells are filled below acertain cell?
On Monday, April 2, 2012 11:01:49 AM UTC-4, V L wrote:
would like the top cell to automatically tell me how many cells below it have text. thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I make an equation to count how many cells are filled below a certain cell?
Hi
Not sure if i understand but try this : =counta(A3:A200) Adjust the range to your needs. Cimjet "V L" wrote in message ... would like the top cell to automatically tell me how many cells below it have text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count filled cells in range if they are one after the other | Excel Worksheet Functions | |||
| How do I get a count of number of cells filled in? | Excel Discussion (Misc queries) | |||
| count filled cells | Excel Programming | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Count Rang of Filled-In Cells | Excel Worksheet Functions | |||
Linear Mode
