Counting Cell or Range

[muhammad susanto]

hi all..

how to counting this :

Excel 2007 32 bit

	E​
3​	data
4​	3​
5​
6​	after formula
7​	=E4+1

Sheet: Sheet1

i want the result is =E5 (E4+1) not 4 included mark "="

any help is greatly appreciated..

m.susanto

 

[Scott Huish]

In L169:
=T(IF(MOD(ROWS($A$1:A1),16)=1,INDEX(N:N,-INT(-(ROWS($A$1:A1)-1)/16)+2),""))

Copy down.