| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula 4 number of cells/rows in a range
i am trying to figure out two formula's
1. a formula to place the number of rows in a range into another cell. ie. ? rows in range A38:C97 to be put into cell A5... 2. as above but how many cells instead of rows, but.. the cells can be both blank and with content in it ... i thought of =countblank() and =counta() but i dont know how i can add them??? -- "The difference between Possible and Impossible is the measure of ones will" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Variable Determines Number of Cell in Formula Range | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
| Formula for displaying the lowest number of a range? | Excel Worksheet Functions | |||
Threaded Mode
