Plse Advice

  • Thread starter Thread starter Michael168
  • Start date Start date
M

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
 
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.
 
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.
 
Michael168 said:
*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. *
Click to expand...
 
Back
Top