Countif Help calli <calli.2cngo5_1155760238.6789[ at ]excelforum-nospam.com> 16.08.2006 20:27:14 Hi, I'm trying to count the number of time a specific value appers with in a range of cells, but I want to place the results in a seperate workbook. How do I do this. Thanks in advace for any help Calli -- calli ------------------------------------------------------------------------ calli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37561 View this thread: http://www.excelforum.com/showthread.php?threadid=572395

Re: Countif Help "Bob Phillips" <bob.NGs[ at ]somewhere.com> 16.08.2006 21:29:10 =SUMPRODUCT(--('C:\myDocs\[myBook.xls]Sheet1'!$A$1:$A$20="a")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "calli" <calli.2cngo5_1155760238.6789[ at ]excelforum-nospam.com> wrote in message news:calli.2cngo5_1155760238.6789[ at ]excelforum-nospam.com... [Quoted Text] > > Hi, > > I'm trying to count the number of time a specific value appers with in > a range of cells, but I want to place the results in a seperate > workbook. How do I do this. > > Thanks in advace for any help > > Calli > > > -- > calli > ------------------------------------------------------------------------ > calli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37561 > View this thread: http://www.excelforum.com/showthread.php?threadid=572395 >

RE: Countif Help Sarah_Lecturer 18.08.2006 08:17:02 Click where you want the answer to go =countif(range,"value") Enter (hilight the range on the other worksheet using the mouse once you have entered =countif( "calli" wrote: [Quoted Text] > > Hi, > > I'm trying to count the number of time a specific value appers with in > a range of cells, but I want to place the results in a seperate > workbook. How do I do this. > > Thanks in advace for any help > > Calli > > > -- > calli > ------------------------------------------------------------------------ > calli's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37561 > View this thread: http://www.excelforum.com/showthread.php?threadid=572395 > >