Peo, you are the Man!

Thanks so much. That worked! So let me understand this for future reference.
Since cells that contain formulas with "" (False) opposed to data,
subtracting them is a problem, however, simple addition is not, correct?
Therefore, the formula you wrote should work in senerios as such?

Peo Sjoblom wrote:
I assume the blanks are from a formula with "" as opposed to empty? Anyway
since SUM ignores text (that is what "" is) you can use something like

=(SUM(G24:G91)-SUM(G87,G89))/(SUM(F24:F91)-SUM(F87,F89))

Very Nice...that was it! Thank You.
Another question reagrding the same formula... I would like to subtract
[quoted text clipped - 16 lines]
if the logical test is false". Your IF does not appear to contain that
logical test.

--
Message posted via http://www.officekb.com