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?