make a Year to date column

Can someone please suggest how I can get the year to day column display
Nothing if there is not anything in the preceding column?

Eg... Column K is YTD. Column J is Invoice total. I figured out how to
hide the zeros in the J column... but can't figure out how to make K show
nothing until there is a figure in J.

Its a simple sheet. Just adds invoices.. and provides a YTD figure. But
looks DUMB when the last YTD figure is carried all the way down the column.

Thank you ...

Try something like this
in say, K2, copied down:
=IF(J2="","","<yourCumuYTDformula>")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Nick" <[email protected]> wrote in message
news:u3i9e.1077135$6l.1005696@pd7tw2no...
> Can someone please suggest how I can get the year to day column display
> Nothing if there is not anything in the preceding column?
>
> Eg... Column K is YTD. Column J is Invoice total. I figured out how to
> hide the zeros in the J column... but can't figure out how to make K show
> nothing until there is a figure in J.
>
> Its a simple sheet. Just adds invoices.. and provides a YTD figure. But
> looks DUMB when the last YTD figure is carried all the way down the
column.
>
> Thank you ...
>
>

Tried that but it doesn't work for the column. I got this:

82.00 82.00
441.00 523.00
210.00 733.00
109.00 842.00
842.00
842.00
842.00
842.00
842.00
842.00
842.00
842.00


I need all those 842.00 to show nothing because there is no entry in the
previous column.

Nick.


"Max" <[email protected]> wrote in message
news:[email protected]...
> Try something like this
> in say, K2, copied down:
> =IF(J2="","","<yourCumuYTDformula>")
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Nick" <[email protected]> wrote in message
> news:u3i9e.1077135$6l.1005696@pd7tw2no...
>> Can someone please suggest how I can get the year to day column display
>> Nothing if there is not anything in the preceding column?
>>
>> Eg... Column K is YTD. Column J is Invoice total. I figured out how
>> to
>> hide the zeros in the J column... but can't figure out how to make K show
>> nothing until there is a figure in J.
>>
>> Its a simple sheet. Just adds invoices.. and provides a YTD figure. But
>> looks DUMB when the last YTD figure is carried all the way down the
> column.
>>
>> Thank you ...
>>
>>
>
>

Assume this data is in J2:J5

> 82.00
> 441.00
> 210.00
> 109.00

Put in K2: =IF(J2="","",J2)

Put in K3: =IF(J3="","",SUM(J3,K2))
Copy K3 down

Assuming cells J6, J7, etc are currently empty,
you should get in cols J to K

> 82.00 82.00
> 441.00 523.00
> 210.00 733.00
> 109.00 842.00

(rest of col K will appear "blank")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Nick" <[email protected]> wrote in message
news:3Xk9e.1077177$8l.497928@pd7tw1no...
> Tried that but it doesn't work for the column. I got this:
>
> 82.00 82.00
> 441.00 523.00
> 210.00 733.00
> 109.00 842.00
> 842.00
> 842.00
> 842.00
> 842.00
> 842.00
> 842.00
> 842.00
> 842.00
>
>
> I need all those 842.00 to show nothing because there is no entry in the
> previous column.
>
> Nick