Hi

what sheet is the A3 on?

personally, i can't see anything wrong iwth that you've done, but i'm not
sure why you're using the SUMPRODUCT function for this, as you're only
testing one criteria the SUMIF should work just as well:

=SUMIF('Pal CluB Renov 2.2'!$A$1:$A$513,A3,'Pal CluB Renov 2.2'!$L$1:$L$513)

Cheers
JulieD


"MHoffmeier" wrote in message
...
I am using the following formula:
=SUMPRODUCT(--('Pal CluB Renov 2.2'!$A$1:$A$513=A3)*--('Pal CluB Renov
2.2'!$L$1:$L$513))
It works great if it is within the sheeet that is referenced, but does not
work if it is in another sheet in the same workbook. Where am I going
wrong?