count number of cells between two cells

[Tresfjording]

Hi ...
How do I count the number of cells between to cells in a sheet, preferably without the use of VBA?

 

[Georgiboy]

Do you have any criteria, blanks, non-blanks etc.?

Or just count cells:

Book1
	A	B	C	D	E
1
2
3					24
4					24
5
6
7
8
9
10
11
12
13
14
Sheet1

Cell Formulas
Range	Formula
E3	E3	=ROWS(B3:C14)*COLUMNS(B3:C14)
E4	E4	=SUMPRODUCT(ROWS(B3:C14),COLUMNS(B3:C14))

 

[Tresfjording]

No criteria, just count the cells

 

[Tresfjording]

Do you have any criteria, blanks, non-blanks etc.?

Thank you, this works fine, with indirect() too.