I have a simple formula to add cells but sometimes I have text in them and I need excel to ignore the text and not give me the "#VALUE" error.

My sheet adds up daily productions for the amount of dirt moved on a project. If it is a rain day I simply type "rain" in the cell to track the weather days.

I had this sheet in Lotus and when I converted it to excel now I get the error due to the text.