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"

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"

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"

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"

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"