I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7), B2's formula is something like
That way if I add some value in cell A8, the count is updated to 8 in cell B2. And so on and so forth when values are filled in cells A9, A10, ... etc, the count in cell B2 always keeps track of the current number of items in the list.
It would be very handy to have the ability of creating a named range, called
items for instance, based on the count in cell B2 using
to define the named range.
items could be used anywhere and would get dynamically updated when the item list is modified.
This is the way it can be done in Excel, but what would be the corresponding approach using Google Sheets?