Hello:
Please refer to attached file.
I need a formula to count the number of entries in column N,R,V,Z and so on row 40 down.
I have manually entered 6 and 4 in cell N5 and N6
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I need a formula to count the number of entries in column N,R,V,Z and so on row 40 down.
I have manually entered 6 and 4 in cell N5 and N6
Let me know if you have any questions.
Thanks.
Riz
try
=COUNTA(INDIRECT(G5&"40:"&G5&"200"))
you change the 200 to whatever row you wish to count from 40 upto
Last edited by etaf; 05-12-2016 at 10:08 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi etaf:
Thanks a lot...works
Riz
your welcome , thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks