Countif Help

  • Thread starter Thread starter calli
  • Start date Start date
C

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)
 
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(
 
Back
Top