Thread: Sum portion of column based on row content
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JeffC JeffC is offline
external usenet poster
  
Posts: 15
Default Sum portion of column based on row content
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?
Reply With QuoteReply With Quote