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

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

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

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


.

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