How can I count the no. of entries in a column.

B

Barnali

Hi
I have to count the no. of entries in a particular column in a sheet
named "Updated Overflow".Whenever new entries are added the total no.
should appear in a particular cell in another sheet named "WTS".Could u
please help me to write a macro for this.

Thanks in advance.
 
B

Bob Phillips

You don't need a macro, jus

=COUNTA('Updated Overflow'!A:A)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
S

starguy

you can do this by using COUNTA function.
suppose you have data in col A of Updated Overflow sheet, put in your
specified cell in WTS sheet the following function.
=COUNTA(A1:A100)

you can extend this range

hope this would help you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top