The formula you're using in column X should make this slight revision work
in column Y:

=IF(X3"",SUM($X$3:X3),"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tonya Marshall" wrote in message
...
Tonya Marshall wrote:

RagDyeR wrote:

=SUM($X$3:X3)
will copy the last total all the way down in my sheet.

=IF(X30,SUM($X$3:X3),"")
Will leave column Y *empty* when column X is empty, or, if column X
displays
a zero from your "=DAYS360(A3,V3)" formula.

Are you sure that you copied it exactly?
What exactly do you have in column X?

I copied and pasted your formula into Y3


That should be: "Formula in Column X," below.

This is the formula I have in Column V. It's set up so that if A and V
are the same date it returns a 1. The column below the last figure is
blank.
=IF(OR(A3="",V3=""),"",IF(DAYS360(A3,V3)=0,1,DAYS3 60(A3,V3)))



--
Tonya Marshall
tonz AT harborside DOT com