Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif Help
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif Help
=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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif Help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |