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

[Guest]

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]

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