If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
summing two columns of different data
I need to sum a dollar total from two different types of columns. One column
identifies the item and another column associates a dollar amount with that item. The items are different tree species and the dollar amounts are the pruning costs associated with a specific tree species in a given year. For example: Column A Column B Column C Species 2011 2012 Lemon tree $100 Apple tree $50 Lemon tree $150 Cherry tree $50 $50 I want to sum the total dollar amount to prune only the lemon trees in 2012. Presently, I am using a COUNTIF to sum the total number of lemon trees, but I need to also sum the cost of pruning just those lemon trees. Column D Column E Column F Trees by species Total 2012 pruning cost Lemon trees 2 $250 (need formula to get this sum) Using one formula, can I fill the cells in both Column E and Column F? -- Dick Scoppettone |
#2
|
|||
|
|||
summing two columns of different data
=SUMIF($A:$A,"Lemon tree",B:B)
Will give you total for 2011. Copy one cell to the right to get total for 2012. -- Best Regards, Luke M "Dick Scoppettone" (donotspam) wrote in message ... I need to sum a dollar total from two different types of columns. One column identifies the item and another column associates a dollar amount with that item. The items are different tree species and the dollar amounts are the pruning costs associated with a specific tree species in a given year. For example: Column A Column B Column C Species 2011 2012 Lemon tree $100 Apple tree $50 Lemon tree $150 Cherry tree $50 $50 I want to sum the total dollar amount to prune only the lemon trees in 2012. Presently, I am using a COUNTIF to sum the total number of lemon trees, but I need to also sum the cost of pruning just those lemon trees. Column D Column E Column F Trees by species Total 2012 pruning cost Lemon trees 2 $250 (need formula to get this sum) Using one formula, can I fill the cells in both Column E and Column F? -- Dick Scoppettone |
#3
|
|||
|
|||
summing two columns of different data
Take a look SUMIF() in help menu
"Dick Scoppettone" wrote: I need to sum a dollar total from two different types of columns. One column identifies the item and another column associates a dollar amount with that item. The items are different tree species and the dollar amounts are the pruning costs associated with a specific tree species in a given year. For example: Column A Column B Column C Species 2011 2012 Lemon tree $100 Apple tree $50 Lemon tree $150 Cherry tree $50 $50 I want to sum the total dollar amount to prune only the lemon trees in 2012. Presently, I am using a COUNTIF to sum the total number of lemon trees, but I need to also sum the cost of pruning just those lemon trees. Column D Column E Column F Trees by species Total 2012 pruning cost Lemon trees 2 $250 (need formula to get this sum) Using one formula, can I fill the cells in both Column E and Column F? -- Dick Scoppettone |
#4
|
|||
|
|||
summing two columns of different data
Thanks, Luke - works like a charm!!!
-- Dick Scoppettone "Luke M" wrote: =SUMIF($A:$A,"Lemon tree",B:B) Will give you total for 2011. Copy one cell to the right to get total for 2012. -- Best Regards, Luke M "Dick Scoppettone" (donotspam) wrote in message ... I need to sum a dollar total from two different types of columns. One column identifies the item and another column associates a dollar amount with that item. The items are different tree species and the dollar amounts are the pruning costs associated with a specific tree species in a given year. For example: Column A Column B Column C Species 2011 2012 Lemon tree $100 Apple tree $50 Lemon tree $150 Cherry tree $50 $50 I want to sum the total dollar amount to prune only the lemon trees in 2012. Presently, I am using a COUNTIF to sum the total number of lemon trees, but I need to also sum the cost of pruning just those lemon trees. Column D Column E Column F Trees by species Total 2012 pruning cost Lemon trees 2 $250 (need formula to get this sum) Using one formula, can I fill the cells in both Column E and Column F? -- Dick Scoppettone . |
#5
|
|||
|
|||
summing two columns of different data
Thanks - your SUMIF started me in the right direction, then Luke closed the
deal. -- Dick Scoppettone "Teethless mama" wrote: Take a look SUMIF() in help menu "Dick Scoppettone" wrote: I need to sum a dollar total from two different types of columns. One column identifies the item and another column associates a dollar amount with that item. The items are different tree species and the dollar amounts are the pruning costs associated with a specific tree species in a given year. For example: Column A Column B Column C Species 2011 2012 Lemon tree $100 Apple tree $50 Lemon tree $150 Cherry tree $50 $50 I want to sum the total dollar amount to prune only the lemon trees in 2012. Presently, I am using a COUNTIF to sum the total number of lemon trees, but I need to also sum the cost of pruning just those lemon trees. Column D Column E Column F Trees by species Total 2012 pruning cost Lemon trees 2 $250 (need formula to get this sum) Using one formula, can I fill the cells in both Column E and Column F? -- Dick Scoppettone |
Thread Tools | |
Display Modes | |
|
|