What I would start off doing, would be to put this formula in the *actual*
sheet that the real data was located in, to eliminate all the path info.
Then I would eliminate all the *excess* operators, namely, there's *no* need
for both the double unary and the asterisk.

This would leave the formula on the *real* data sheet (producerytd) as:

=SUMPRODUCT(($A$2:$A$8100=G4)*($M$2:$M$8100=G5)*$Q $2:$Q$8100)

You'd of course have to add the criteria of G4 and G5 to the G4 and G5 of
*this* sheet.

NOW, what do you get with this test?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ken8795" wrote in
message ...

Your advice worked perfectly on my test file. I went to use the
function with my real data file and received an error message...

Microsoft Excel

Excel cannot complete this task with available resources. Choose less
data or close other applications.

The only option available is the OK button which closes Excel.

Excel is the only application running. The real data sheet has just
under 8100 rows, so I attempted to reduce the outside range to 8100,
and continue to receive the same error whenever I attempt to enter the
formula in.

The final formula I am using is...

=SUMPRODUCT(--('C:\Documents and Settings\Ken\My
Documents\[producerytd.xls]Sheet1'!$A$2:$A$8100=G4)*(--('C:\Documents
and Settings\Ken\My
Documents\[producerytd.xls]Sheet1'!$M$2:$M$8100=G5)*(--('C:\Documents
and Settings\Ken\My
Documents\[producerytd.xls]Sheet1'!$Q$2:$Q$8100))))

Any Ideas


--
ken8795
------------------------------------------------------------------------
ken8795's Profile:
http://www.excelforum.com/member.php...o&userid=36411
View this thread: http://www.excelforum.com/showthread...hreadid=561851