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?

Try this:

=Sumif(A:A,"Area",C:C)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"lt" wrote in message
...
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?