View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelzina Kelzina is offline
external usenet poster
 
Posts: 12
Default 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"