Ok,
I have read literally every thread on the use of sumproduct for
multiple workbooks BUT still cannot get it to work for my project.
Here are the details:
*1-* I have 3 separate WORKBOOKS
*2-* Each workbook has a different file name but contains the same
information b/c it is a template sent to sales people. Let's say the
names are Brown.xls, Curry.xls, & Matthews.xls
*3-* On worksheet entitled "Monthly Report" cell range C15-C24 needs to
be summed IF it contains at certain value (let's say "2").
*4- *The sumproduct formula is being placed in a summary Workbook
entitled "Cumulative Monthly Report"
*What is the complete SUMPRODUCT formula for this?*
PLEASE HELP!
--
chanbrig
------------------------------------------------------------------------
chanbrig's Profile:
http://www.excelforum.com/member.php...o&userid=36071
View this thread:
http://www.excelforum.com/showthread...hreadid=558587