I Have a set of values in a column that keeps track of customers for a given
product. I have a CountA function set up to count the non-null values in the
range, thus keeping track of how many customers I have for a given product.
My problem is this:
When I create a new row in the table to insert a new customer, that entry
now falls a row outside of my defined, named range, and the new entry doesn't
get counted in my COUNTA. Is there a way to redefine (stretch) the range I
have defined as "customers" so that it automatically grows row by row each
time I ADD insert a new row?