|
|
#4
03-19-2015, 01:20 PM
|
|||
|
|||
Assuming Names in A and count in B within the sheet of Caseload Test workbook and ‘Cases’ (edit to suit ) is the sheet name within the workbook ‘Pipeline Test’ then….
Eg in B2 =COUNTIFS('[Pipeline Test]Cases'!I2:I1000,'Caseload Test'!A2,'[Pipeline Test]Cases'!M2:M1000,"Yes”) and copy down. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
 #REF! error when opening a workbook that contain a refference to another workbook
|
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
|
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
|
Select a range in one one workbook while working in other workbook
|
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |
Windows 8 
Office 2013
Threaded Mode