Inconsistent formula problem Excel 2002?

[Ben]

Greetings,

In Excel 97 I had this formula in cell D12
=IF(C12<>"",IF(B12>0,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

 

[Ben]

Since the formula still gives the correct result I went
and clicked on "Ignore Error". I am just checking if this
would be an acceptable practice or is there something
underlying I should know about. According to the help, it
says that if an adjacent formula is different than the one
with the issue, you will get an error notification.

 

[Dave Peterson]

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.

 

[Dave Peterson]

I think if you know what you're doing, then it's fine to ignore that error.

I think it's there to help you when you're copying and pasting (or filling) that
one of your formulas is not like the other.

And excel can find the inconsistency pretty easily--but it doesn't really know
what you want.