For example if you have:
=COUNTA(Overview!L3:L6)
But then you add like 3 more rows of data, so I would like the formula to automatically update to:
=COUNTA(Overview!L3:L9)
For example if you have:
=COUNTA(Overview!L3:L6)
But then you add like 3 more rows of data, so I would like the formula to automatically update to:
=COUNTA(Overview!L3:L9)
One of the best ways is to use Dynamic Named Ranges.
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks