Fairly new to excel and am stuck with a problem that should be fairly easy.
I am doing a calculation in one column that involves a variable that is the sum of a separate column. In a third column if "Y" is typed I need that variable to be set to zero, so I have tried an if statement that if "Y" is typed all cells are set to zero.. But once a "Y" has been typed all the cells are =0 and thats it! I need a function that will clear all the cells when "Y" and then continue to add the following data as it is entered into the column, and then the column cleared when "Y"?

Is there a function in excel that clears an entire column or sets it to zero temporarily?