Dynamic range with count ?
Dear all,
I have a row, contains numbers,
i want to count how many number on that row, Result must be dynamic 'cos i offten add/delete them
Thanks in advance,
G'day,
Use the count function.
But were are you placing the formula, is it on the same row of the deletion ?
Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
Please don't forget to do the same to other contributors of this forum.
Thanks
I don't void confusion, I create it
I place the function below 1 row which row i want to count ?
G'day again,
Say you want to count row 4
Edit: I've add attachment after some though. It a macro will insert a count formula and count the row above the edit box=COUNT(4:4)
Eg To count row 4, place the edit box in the row 5 (it doesn't matter where). Press the macro button. The count for row 4 is done.
To count row 1 place edit box in row 2. To count row 102 place edit box in row 103.
Hope that helps
Last edited by ratcat; 06-22-2008 at 08:09 AM.
Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
Please don't forget to do the same to other contributors of this forum.
Thanks
I don't void confusion, I create it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks