Sum portion of column based on row content

[JeffC]

Hi,

I have an asset schedule that lists assets in rows. Is there any way to sum
the column that has cost basis... but exclude the rows where there is an
entry in the "disposed" column? See the following example:

Asset_Name Cost Disposal_Date
Asset_1 10.00 5/30/09
Asset_2 15.00

Can I sum the "cost" column and get a result of $15.00?

 

[Don Guillett]

Look in the help index for SUMIF
=SUMIF(I2:I22,"="&"",H2:H22)

 

[T. Valko]

Try something like this:

=SUMIF(C2:C10,"",B2:B10)