in cell A8:
=IF(A7="","",IF(A7=63,35,""))
--
hope to help,
cm


"Brandon" wrote:

Here is a brief and thrown together explanation of what I want:

In cell A7 I want SUM(A1:A6)IF(SUM(A1:A6<0) AND IF(SUM(A1:A6=0)Leave Blank
In cell A8 I want IF(A7=63)Then 35, ELSE Leave Blank


Here is what I am currently using.

In cell A7
=IF(SUM(A1:A6)<0,SUM(A1:A6),"")
In cell A8
=IF(A7=63,35,"")

It works, however the when A7 is blank, A8 displays 35 instead of being
blank. I tried using SUMIF in A7 but when the sum of A1:A6 was 0 the cell
displayed a 0 instead of being blank.

Thanks in advance for any help.

Brandon