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?
|