Named range moving horizontally corresponding row

[godlev]

the named range should refer to corresponding row where the formula uses the named range and it should be E:AI

so lets say we call the named range XXX
if i enter formula on 3rd row

counta(XXX,1)

the formula should count the range E3:AI3
if i expand the formula on the next row 4
the formula should cont the range E4:AI4

and so on...

 

[godlev]

sorry small mistake in formula =counta(xxx)

 

[RoryA]

Select a cell in row 3. Then define the name XXX to refer to =$E3:$AI3

 

[godlev]

thank you works like charm!
i tried many different combinations but never this one