"Rescueme" wrote in message
...
David my information is coming from a seperate sheets in cells
'2008_Data'!B4:H4
Current formula in first cell is: =SUM(1100-'2008_Data'!B4) in this one I
am
having 1100 show up as an answer in all cells.

In every case *please* get rid of the unnecessary SUM() function. Look in
Excel help at what SUM() does. It takes a list of separate arguments and
adds them together. You don't have a list of separate arguments that you
want to add together, so you don't want the SUM function.

=IF('2008_Data'!B4="","",1100-'2008_Data'!B4)

in second cell is: =SUM('2008_Data'!C5-'2008_Data'!C4) - this type are
showing with a 0 value

=IF(COUNT('2008_Data'!C5,'2008_Data'!C4)=2,'2008_D ata'!C5-'2008_Data'!C4,"")

in third cell is: =SUM((F4*1000/D4)) - her I get the standard error
#DIV/0!

=IF(OR(D4=0,F4=""),"",F4*1000/D4)
--
David Biddulph