Hi!

You just have it backwards.

Try it again so that Excel puts in the path.

Open file 2006 Master List.

In the file where you want this formula:

Enter:

=COUNTIF(

Now, navigate to 2006 Master List select the tab and range.

Finish the formula by typing in the comma and 0) then hit Enter.

The formula should look like this:

=COUNTIF('[2006 master list.xls]Totals'!$S$2:$S$78,0)

Biff

<goldcomac@mac.com> wrote in message
news:1148793829.509337.290890@j73g2000cwa.googlegroups.com...
> 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.
>