You want to subtract the total of one sheet from another?

=SUM(Sheet2!1:65536)-SUM(Sheet1!1:65536)

entered in a third sheet or else you would get circular reference errors

I doubt that is what you want though, maybe you could clarify?

Regards,

Peo Sjoblom

"jennifer" wrote:

I have two sheets in the same format. Is there a quick way to subtract the
entire sheet one from the other or do I have to resort to just doing a
subtract formula and copying to relevant cells?

Thanks!