=(Crosstree!$B$28-'Previous Day'!$E5)/2

The parentheses are necessary to ensure the subtraction is done before the
division. Division has precedence over subtraction. The single quotes around
Previous Day are necessary because the sheet name has a space in it. There
is no need for single quotes around Crosstree as there is no space. There is
no need to use the SUM function.

Tyro


"jeannie v" wrote in message
...
Hi Experts:

All I want to do in Cell B7 on a worksheet is take 38 on a separate
worksheet in B28 and subtract 11 on a different worksheet in E5 and then
divide it by 2 with the result returned in Cell B7...Seems simple
enough...don't know what I have wrong in the formula...

In "Overview" Cell B7
=SUM('Crosstree'!$B$28)-('Previous Day!$E5)/2

Can someone please help me? Thank you for your expertise.

--
jeannie v