SUMIF Cells in range if values in another range is

[ChrisNor]

Hi,

I'm not sure whether the title explains the problem or not.

But I have several dates in date format in column A

eg.
Column A:

01.01.2009
01.02.2009
..
..
..
01.01.2010


Column B:

45
26
..
..
..
34


I like to make a Formula that Sums up all the rows in column B that are within a certain year given in Column A.

eg.

If year is 2009, sum 45 + 26
If year is 2010, sum 34

Is there a way I can add formulas to do this in Excel, or will I need to tap into VBA?

[NBVC]

Try

=Sumproduct(--(Year(A1:A100)=2009),B1:B100)

Where A1:B100 contain your raw data

You can replace 2009 with a cell reference containing 2009...