You could break your worksheet and use a formula like:

=sum(d6:d11)

The formulas will be consistent, but it won't be what you want.

Ben wrote:

Greetings,

In Excel 97 I had this formula in cell D12
=IF(C12<"",IF(B120,C12/B12,0),"")

In cells C12 and B12 I had this:
=SUM(C6:C11)
=SUM(B6:B11)

In Excel 2002 even if I place some numbers in B6:B11 and
C6:C11 I get an Inconsistent formula message. How can I
modify the formula above to make it consistent?

Thanks,
Ben

--

Dave Peterson