counting cells

[dave h]

Hi

this may seem a daft question but i'm having real problems trying to count
cells...

i want to count cells in a range say a17 to a40 inclusive - i want to know
the total number of cells in a range and for it to include all types eg
empty cells,text numbers and formulas

sam

 

[Frank Kabel]

Hi
try:
=ROWS(range)*COLUMNS(range)