Absolute cell references
 

Hi Newman,
you should be able to use both relative AND absolute.
Do you mean you can't do the absolute:
=SUM(Sheet2!$A$1:$A$20)
but you can do the relative:
=SUM(Sheet2!A1:A20)
?

Regards,
Sebastien

"Newman" wrote:

Why can't I put in absolute cell references in a formula when the cell being
referenced is on another sheet in the same workbook?