How do I incorporate ref. range(like OFFSET() ) in a function?
 

I want to find out COUNTA() with a given reference range. But the reference
range should be changed automatically when I add/remove the cell

How do I incorporate ref. range(like OFFSET() ) in a function?
 

Maybe you mean something like:
http://contextures.com/xlNames01.html#Dynamic
(From Debra Dalgleish's site)

Vinod wrote:

I want to find out COUNTA() with a given reference range. But the reference
range should be changed automatically when I add/remove the cell

--

Dave Peterson