where there is no value in one of the columns - with this
formula =IF(M8=O8,Q8+N8-1,Q8+N8)
- it says "# Value" in the column and does not carry the
total over on the one column with a total in it - is there
something I can do to get the same result when one column
is empty example below

Column A B c D E f G
03/03/04 03/03/04 1 03/03/04 003/05/04 2 3

03/03/04 03/03/04 1 #value

in the second row colum G I would like it to be able to
carry the one over from column C -- so g needs to
recognize when B and D are the same and subract one but
also needs to carry over colmn C when there is noting in F

Thanks Katherine