| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count the no. of entries in a column.
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the no. of entries in a column.
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) "Barnali" wrote in message oups.com... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I count the no. of entries in a column.
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. Barnali Wrote: 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. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572567 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
| Only count columns if the column next to it is not blank | Excel Discussion (Misc queries) | |||
| Column A = X, Column B =y count = count +1 | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
