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
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
=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" <[email protected]> wrote in
message news:[email protected]...
>
> 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...o&userid=37561
> View this thread: http://www.excelforum.com/showthread...hreadid=572395
>
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:
>
> 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...o&userid=37561
> View this thread: http://www.excelforum.com/showthread...hreadid=572395
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks