| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Cell Occupation
Hi All In cell C20 I need to put the amount of cells in the range D6 - D17 which have content. It's not the total of the content , simply to register how many of the cells in the range have anything in them. If three are occupied then C20 should read three , and so on. Can someone help with a formula? Grateful for any advice. Best Wishes |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Cell Occupation
=COUNTA(D6:D17)
-- Gary''s Student - gsnu200903 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating Cell Occupation
In article , Gary''s
Student writes =COUNTA(D6:D17) - OK that's perfect. Thanks for your help. Best Wishes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Calculating in the same cell | Excel Worksheet Functions | |||
| Disc space occupation | Excel Discussion (Misc queries) | |||
| Huge disc space occupation | Excel Discussion (Misc queries) | |||
| Calculating two numbers in one cell | Excel Worksheet Functions | |||
| calculating from last inputted cell | Excel Discussion (Misc queries) | |||
Linear Mode
