It works now. I had one cell that had something wrong with it. Thanks.

"Ron Rosenfeld" wrote:

On Wed, 11 May 2005 14:39:18 -0700, heater
wrote:

The problem is it totals everything in column "I", no matter if cell
K25:k85="Yes", "No" or is blank. If column K25="NO", I do not want it to
total the sum in cell I25.


I can't reproduce this problem. You will need to provide more information. A
similar formula on my worksheet works as you describe.


--ron