Autocount of data from other excel worksheets

[vivtimmis]

How do I autoinsert a count on another worksheet when entering arrival/departure times in a worksheet. The count sheet should fill each hour with the digit 1 and then count each 1 at the bottom of the summary worksheet.

[FlapperQuack]

Morning Viv,
Not sure i understand the first part of your question, but the second is easily overcome using COUNTIF. For example:
=COUNTIF(A1:A10,"1")
Here, it will search the cells from A1 through A10, for the value 1. As its in quotes, Excel thinks its looking for some text, so you could equally make it search for "Tuesday" or "Train". You can also make it cross reference sheets by putting the sheet name in front of the cell names. For example:
=COUNTIF('Sheet2'!A1:A10,"1")
Notice you use single quotes this time and an exclamation mark. Sheet1 obviously refernces the sheet you're trying to count from.
This of course can be done easier by typing "=COUNTIF(" then after typing the open bracket, using the mouse to click onto the other sheet.

[vivtimmis]

I have a workbook with a sheet that has hours in the columns for arrival/departure of trains. The rows indicate the train ID's. On another worksheet I currently have the same setup which I place the number 1 in the hour column to indicate the train has arrived/departed. This then totals the 1's in a total row. I would like the 2nd sheet to autofill 1's in each hour for each train that arrives/departs to sum the trains that move over a 24 hour period. Thanks.

[Hapus]

Hi there.
If you have two sheets (e.g. sheet1 and sheet2)
to reference the other sheet you do the following:
COUNT('sheet1'!A53:A55) - the quotes are important here.
So in sheet2 you can reference back to sheet1.,
Its a little hard to explain in words! Hope this makes sense.