Plse Advice

[Michael168]

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

 

[David McRitchie]

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.

 

[Michael168]

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.

 

[Don Guillett]

Take a look in HELP index for COUNTIF

 

[Michael168]

*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. *