question about formula based on another workbook info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the CountIF function in Workbook A that counts info in a
range of cells located in Workbook B. I'd like Worksheet A to update when
changes to Worksheet B is made. But the function only works if Workbook B is
open, otherwise I get the dreaded #VALUE! error. What am I doing wrong?

Thanks!!
 
Why don't you place the Cound function in workbook B itself, and then link to
the cell that has the count formula from Column A. That way the workbook
will not need to be opened for formula to calculate.

Or you could save Workbook A and Workbook B as a workspace and then open the
workspace when you need to.
 
try it this way with the path, etc
=COUNTIF('C:\yourfolder\[yourfilename.xls]yoursheet'!$B$5:$B$9,"criteria")
 
I should have said
=SUMPRODUCT(('C:\yourfolder\[yourfilename.xls]yourworksheet'!$B$5:$B$9="SF")*1)
 
Worksheet B is a list of applications sold in a given month and each
application has an employee name for who sold the application. Worksheet A
lists all the employees and I'd like it to count how many times it sees that
employee's name on Worksheet B. There really isn't room on Worksheet B to
list all the employees and since all the employees are listed on Worksheet A,
I thought I could do the function there. I'm going to try Don Guillett's
suggestion.

Thanks for the help!!
 
Thanks, that worked perfectly!!!

Don Guillett said:
I should have said
=SUMPRODUCT(('C:\yourfolder\[yourfilename.xls]yourworksheet'!$B$5:$B$9="SF")*1)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Treesy said:
I am trying to use the CountIF function in Workbook A that counts info in a
range of cells located in Workbook B. I'd like Worksheet A to update when
changes to Worksheet B is made. But the function only works if Workbook B
is
open, otherwise I get the dreaded #VALUE! error. What am I doing wrong?

Thanks!!
Click to expand...
Click to expand...
 
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
Treesy said:
Thanks, that worked perfectly!!!

Don Guillett said:
I should have said
=SUMPRODUCT(('C:\yourfolder\[yourfilename.xls]yourworksheet'!$B$5:$B$9="SF")*1)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Treesy said:
I am trying to use the CountIF function in Workbook A that counts info
in a
range of cells located in Workbook B. I'd like Worksheet A to update
when
changes to Worksheet B is made. But the function only works if
Workbook B
is
open, otherwise I get the dreaded #VALUE! error. What am I doing
wrong?

Thanks!!
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Count If Formula Question 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Using cell as worksheet reference (macro) 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
formula between two workbooks 1
Copy same formula to all worksheets in a workbook 1
How to create absolue path link to another workbook (Excel 2003) 1
Copy formulas between workbooks without copying links 8

Back
Top