The last two rows show 0 because of a formula that is reading the top
table? Maybe you can modify this formula to show "" instead of 0 when
no data have been input yet.

Somehow you need to distinguish otherwise, not with 0. Maybe some
labels with months? This all depends on your top table data and your
formulas.

HTH
Kostis Vezerides

jlandes84 wrote:
Yep, you guys were right. Thanks.

However, this presents another problem. It is an actual zero and it's
averaging correctly on the top table.

But there are four more tables below where I set them up in August and
forgot one of the formulas that I used: =AVERAGE(IF(F28:F35<0,(F28:F35)))
due to linking various parts of the top table to some or all of the bottom
four tables.

To make a long story short, say you have eight entries. Six have
automatically entered data (numbers in this case) by what was inputed in the
top table. The last two rows are all showing zeroes, of course, because the
data has yet to be completed above. But, of the six that have been entered,
one IS a zero and it is not being averaged and needs to be.

Any ideas?

Thanks again.