Counting Cell or Range

[muhammad susanto]

hi all..

how to counting this :

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]data[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td]after formula[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]=E4+1[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

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.