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