Geordie,

Use a formula like this in C4, copied to all of column C:

=IF(A4+B4<0,A4+B4,"")

HTH,
Bernie
MS Excel MVP


"Big Geordie" <Big wrote in message
...
I have a spreadsheet, where figures wll be input on a regular basis but over
a long period of time (say (say 12 months), as part of this I have column A
& B which are set to add together (say A4+B4) and but the figure into column
C (at C4). This is where my problem lies as column C is the column used to
find the ongoing Median Yield, but because of the formula in place to ad A+B
togerther I am not getting a true figure for the Median Yield, tried using
the "Hide Zeros" but this does not make a difference any ideas