How do I sum different rows
 

I have a speadsheet that contains the data of a date format and currency
format. For example:
Col A Col B
ROW 1 3/8/2005 $5.00
ROW 2 3/8/2006 $25.00
ROW 3 3/8/2007 $10.00

ROW 20 3/8/2005 $5.00
ROW 21 3/8/2006 $25.00
ROW 22 3/8/2007 $10.00

ROW 33 3/8/2005 $5.00
ROW 34 3/8/2006 $25.00
ROW 35 3/8/2007 $10.00

My questions is... How do i get the sum of Col B for the current year? For
example if I use this year my formula should return $75.00.

Thanks

How do I sum different rows
 

=SUMPRODUCT(--(YEAR(A1:A35)=2006),B1:B35)

------------------
mama no teeth

"btijoe" wrote:

I have a speadsheet that contains the data of a date format and currency
format. For example:
Col A Col B
ROW 1 3/8/2005 $5.00
ROW 2 3/8/2006 $25.00
ROW 3 3/8/2007 $10.00

ROW 20 3/8/2005 $5.00
ROW 21 3/8/2006 $25.00
ROW 22 3/8/2007 $10.00

ROW 33 3/8/2005 $5.00
ROW 34 3/8/2006 $25.00
ROW 35 3/8/2007 $10.00

My questions is... How do i get the sum of Col B for the current year? For
example if I use this year my formula should return $75.00.

Thanks

How do I sum different rows
 

Thank You,
That worked fine.
I changed it a little
=SUMPRODUCT(--(YEAR(A1:A35)=YEAR(TODAY())),B1:B35)

Thanks again

"Nobody" wrote:

=SUMPRODUCT(--(YEAR(A1:A35)=2006),B1:B35)

------------------
mama no teeth

"btijoe" wrote:

I have a speadsheet that contains the data of a date format and currency
format. For example:
Col A Col B
ROW 1 3/8/2005 $5.00
ROW 2 3/8/2006 $25.00
ROW 3 3/8/2007 $10.00

ROW 20 3/8/2005 $5.00
ROW 21 3/8/2006 $25.00
ROW 22 3/8/2007 $10.00

ROW 33 3/8/2005 $5.00
ROW 34 3/8/2006 $25.00
ROW 35 3/8/2007 $10.00

My questions is... How do i get the sum of Col B for the current year? For
example if I use this year my formula should return $75.00.

Thanks