TRY Closing the inverted commas Below:
{=SUM(IF(Quote_Code=A3,Quote_Amt,""))}

Corey....
"Joanne Ramaekers" wrote in
message ...
I have an array formula that is working perfectly:
{=SUM(IF(Quote_Code=A3,Quote_Amt,))}

I would like to make one change, but I don't seem to be able to get it
working. When the locigal test is false I would like to dispaly nothing
in
the cell. It's currently displaying 0.00.

I have tried {=SUM(IF(Quote_Code=A3,Quote_Amt," "))} but is still shows
0.00.

Any ideas?
Jo

P.S. I'm using Office 2003