Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum portion of column based on row content
Look in the help index for SUMIF =SUMIF(I2:I22,"="&"",H2:H22) -- Don Guillett Microsoft MVP Excel SalesAid Software "JeffC" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum portion of column based on row content
Try something like this:
=SUMIF(C2:C10,"",B2:B10) -- Biff Microsoft Excel MVP "JeffC" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort on only portion of a column | Excel Discussion (Misc queries) | |||
Update column H based upon content in column B | Excel Worksheet Functions | |||
how do i remove a portion of data from a column | Excel Discussion (Misc queries) | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
how to create a chart based on the content of a column | Excel Discussion (Misc queries) |