Ashlynn Grace wrote:
Anyone have an idea why this formula would be giving me a #REF!
error? The help guide is of no help at all. I am sure that I don't
have any cells pointing at one another or anything like that. I
don't know if this has anything to do with it, but the cells in
column K have a formula in them that pulls from other cells in the
same workbook to bring over to this new workbook, where the following
formula is placed:

=SUMPRODUCT(('[Production Manager Commission Payroll
Report.xls]Sheet1'!A2:A65536="Curtis B Carter")*('[Production Manager
Commission Payroll Report.xls]Sheet1'!K2:K65536))

It's seem very strange...

I think this should work...

Try this way

=SUMPRODUCT(--('[Production Manager Commission Payroll
Report.xls]Sheet1'!A2:A65536="Curtis B Carter"),('[Production Manager
Commission Payroll Report.xls]Sheet1'!K2:K65536))

If this should not work, you can try to post an example workbook at
www.savefile.com

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy