The first formula you suggested did the trick. Still having the problem of
the #VALUE error down my entire -I- column and my totals for my -I- column
will not calculate in assigned cell. =SUM(I1:I30)

Question: The original formula that started all this is:
=IF(ISBLANK(A1),"",IF(A1<=49.95,12.48,A1*0.5))
The result is to show in B1.
The cell that totals row 1 has the formula: =SUM(H1+B1+C1+D1+E1+F1)
The cell that totals Column I has the formula: =SUM(I1:I30)
The result is to show in I31
Is there anything that seems odd about this or would cause I31 to not show
the results?
ADC76

"Andy_N1708 via OfficeKB.com" wrote:

Change formula to
=IF(ISBLANK(A1),0,IF(A1<=20,12,A1*0.5))

ADC76 wrote:
Hey Andy,
That formula works too. However, I seemed to have created another problem
by entering this formula. Here is the post that I replied to Jacob, but have
not heard back from him yet. Maybe you can help.

"Unfortunately it seems to be throwing of the calcuations of another cell
all together. I'm now getting a #VALUE error message in my totals cell on on
that row. That cell's formula is:
H1+B1+C1+D1+E1+F1
The results show in I1. Only when all cells are blank do I get the #VALUE
error. If data is entered in any cell of Row 1, the formulas work fine.
However, I have a cell at the bottom of column I that is to total all data in
that column, and that formula is not working at all. =SUM(I1:I30)
Thanks for your help."
ADC76

Use this code

[quoted text clipped - 11 lines]
Thanks,
ADC76

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