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