I am trying to take data from two separate workbooks laid out like so:
picker | lines --------+------ zf | 4 ag | 22 jw | 8 zf | 7 cr | 39 ag | 10 ag | 16 ag | 1 cr | 4 ag | 2
... and count the amount of times initials show up and compile them in a completely different workbook. this is the formula I have so far :
=COUNTIF('\\Shipping\C\Agri-Pet Log\2013\November\December\[December 3, 2013.xls]Ag & Pet Shipping'!$B$4:$B$200,"CR")+COUNTIF('\\Foodcomp\c\Dog Food Log\2013\December\[(df) December 3, 2013.xls]Dog Food'!$B$4:$B$300,"CR")
This works great as long as the original workbooks are open on my computer but if they are closed all I get is
#VALUE! Ideally I'd like to also have something add up the numbers associated to the initials in the cells beside them too but one thing at a time.