| 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 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 | |||
![Cimjet[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
