Copying COUNT Formula to another sheet

[exceldummy2014]

I have a cell on one sheet that shows the count of items in a column, but I also want a cell on another sheet that counts the same column of items. How do I do that being that it's another worksheet pulling from another?

 

[juz2gud]

I have a cell on one sheet that shows the count of items in a column, but I also want a cell on another sheet that counts the same column of items. How do I do that being that it's another worksheet pulling from another?

Simple:
In the "another sheet" where u want the same result to be calculated

1)select the CELL in which u want it to be calculated...
2) type -----> "=" (without quotations..)
3) then click the previous sheet (whee the COUNT FORMULA is already running)
4) click the cell in which the COUNT FORMULA is running
5) Press Enter

thts all

 

[exceldummy2014]

wooo hoooooo!!! thanks so much!

 

[juz2gud]

your welcome!