Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a 2nd file
I'm trying to do a 'countif' function and running into problems. I have
one file called 2006 Master List and a second file called 2006 Stats List. I want to publish the Master List and keep a Stats file that is only available to a few people. I want to gather information from the Master List but I'm running into trouble and I'm wondering what I'm doing wrong. In the Stats List, I type =, then click on to the Master List in the proper tab and then type countif (S2:S78,0). Just to be clear, I'm trying to find out how many times the number 0 shows up in S2 thru S78. When I'm done, it looks like this: ='[2006 Master List.xls]TOTALS'! Countif(S2:S78,0). How do I get this to work? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy File Automatically on Opening It | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) |