=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?
--

Regards,

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

"Tonya Marshall" wrote in message
...
It works, but when I copy it down it shows the last total all the way
down. I want column Y empty if there's nothing in Column X

RagDyeR wrote:
One way:

Enter this in Y3, and drag down to copy:

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