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