| 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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula 4 number of cells/rows in a range
=ROWS(A38:C97)
=COUNTA(A38:C97)+COUNTBLANK(A38:C97) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kelzina" wrote in message ... 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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula 4 number of cells/rows in a range
The COUNTA ... COUNTBLANK method can double-count if say one cell contains a
formula that returns "", so maybe =ROWS(A38:C7)*COLUMNS(A38:C97) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kelzina" wrote in message ... 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" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula 4 number of cells/rows in a range
THANKYOU SO MUCH, i knew it had to be fairly basic and close to what i was
already looking at, much appreciated. -- "The difference between Possible and Impossible is the measure of ones will" "Bob Phillips" wrote: =ROWS(A38:C97) =COUNTA(A38:C97)+COUNTBLANK(A38:C97) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kelzina" wrote in message ... 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" |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula 4 number of cells/rows in a range
Note my follow-up post.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kelzina" wrote in message ... THANKYOU SO MUCH, i knew it had to be fairly basic and close to what i was already looking at, much appreciated. -- "The difference between Possible and Impossible is the measure of ones will" "Bob Phillips" wrote: =ROWS(A38:C97) =COUNTA(A38:C97)+COUNTBLANK(A38:C97) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kelzina" wrote in message ... 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" |
| Reply |
| 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 | |||
Linear Mode
