I am looking for a formula that does the following: The word Area is listed
in some cells in the "A" column with the actual area number listed in the "C"
cell. I want to tell the speadsheet that if the "A" column contains the word
area, then add the "C" column of that row. Any suggestions?