Excel Formula Calculation to add some cells
 

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?

Excel Formula Calculation to add some cells
 

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?