Plse Advice
 

May I ask for advice on how to auto update sheet2?
That is I have my data in sheet1. My answer in sheet2.
In sheet2 cell A1 I have the count value of sheet1 range A1:A1875.
So when I add new row of data in sheet1 the new range will be
A1:A1876.
How can I make Cell A1 in sheet2 auto update the count to A1:A1876
instead of manually changing the range everytime I make an update of
rows in sheet A1.

Thank you for your advice and sorry for the troubles caused.

With Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Plse Advice
 

What do you currently have in code or as a worksheet formula.

Is there anything in Column A that is not to be included?

What kind of count, if you included the answer to the first question
this would have been obvious.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Michael168" wrote in message ...
May I ask for advice on how to auto update sheet2?
That is I have my data in sheet1. My answer in sheet2.
In sheet2 cell A1 I have the count value of sheet1 range A1:A1875.
So when I add new row of data in sheet1 the new range will be
A1:A1876.
How can I make Cell A1 in sheet2 auto update the count to A1:A1876
instead of manually changing the range everytime I make an update of
rows in sheet A1.

Thank you for your advice and sorry for the troubles caused.

With Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Plse Advice
 

On Sheet1 the column A range consists of different names.
On sheet2 the cell A1 was use to count / total no times the same names
appear in column A

Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Plse Advice
 

Take a look in HELP index for COUNTIF

"Michael168" wrote in message
...
On Sheet1 the column A range consists of different names.
On sheet2 the cell A1 was use to count / total no times the same names
appear in column A

Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Plse Advice
 

Michael168 wrote:
*On Sheet1 the column A range consists of different names.
On sheet2 the cell A1 was use to count / total no times the same
names appear in column A

=COUNTIF(Sheet1!A5:A1815,"=Dave")


Thank you. *



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/