Linking worksheets
 

I have limited knowledge of formulas. I am trying to subtract totals on
worksheet 1 from total on worksheet 2.

Linking worksheets
 

Try this in a cell on sheet 1.


=Sheet2!A1-Sheet1!A1

Mike


"Central Station Manager" wrote:

I have limited knowledge of formulas. I am trying to subtract totals on
worksheet 1 from total on worksheet 2.

Linking worksheets
 

Simple..in your destination cell where you want the answer to show up, simply
type "=" (w/o quote). Then go right over to Worksheet 2 and click the cell
you want to subtract from. Then type "-". Then go over to the Worksheet 1
and click on the cell you want to subtract. After clicking that cell, hit
enter. Bam your done. Then you can study the resulting formula if you want
to learn the syntax.

So in my head I say, starting at where I want the answer displayed,
"equals(=) THIS (click on cell) minus (-) THIS (click on cell). Enter."
--
-Kaman
The IT dept people call before they call the real IT dept.


"Central Station Manager" wrote:

I have limited knowledge of formulas. I am trying to subtract totals on
worksheet 1 from total on worksheet 2.