Try something like ...
=If(isblank(CKLOG!$G9),"",BUDGET!$D$19)
Rgds,
ScottO


"Denny Crane" <Denny wrote in
message ...
| I have three sheets "Budget", "Cklog" and "Disbursements".
|
| Budget contains several line items annualized in one column and /26
(pay
| periods) in another.
| ________B________________C_______________D________ _____
| 18.| CATEGORY ANNUALIZED PER PAY PERIOD
| 19.| Food $4500.00 $173.07
|
|
| "Cklog" has a column (G8) labled "Net Income". Net is calculated
for each
| pay check
|
| _____E________________F_______________G___________ __
| DATE GROSS NET
|
| 8.| 17FEB06 $191.05 $167.52
| 9.| 03MAR06
|
|
| "Disbursements" has a column "J" labeled FOOD which contains
=BUDGET!$D$19
| copied to all cells (26) in column "J". This causes $173.07 to
appear in all
| cells in column "J". Column "J" is totaled at the bottom causing a
| annualized total instead of an accumulated to total.
|
| How do i keep $173.07 form appearing in "J" until a new entry
appears in
| Cklog[s NET Column
|