Count pricing associated to year

[Neall]

I have part prices (O8 - O23) and years they were purchased (C8 - C23) I want
to create a formula that adds up only parts purchased for X year.

Any suggestions

Thanks in advance

 

[Neall]

Thanks Jacob, but I think we are both missing each others points

I have rows 8 - 23

Column C8 - 23 has the year the parts were purchased
Column D8 - 23 has the part number that was purchased
Column E8 - 23 has the part name that was purchased
Column O8 - 23 has the price paid for that part in its corresponding row

So what I am looking for is to use column C to find the year (07,08,09,2010)
and then add up all the corresponding prices in Column O and give a result.

 

[Neall]

Thanks this worked!

But now I have one problem, even thought the date format is showing 2008,
excel is reading it as (example) 39538 any suggestions?

 

[Neall]

Thanks again for your time Jacob issue resolved now a new one on why excel is
reading my dates as simple 5 digit numbers.

 

[Jacob Skaria]

Neall

In P1 enter 2007, P2 = 2008, P3 = 2009, P4 = 2010

In Q1 enter the formula and copy that down as required
=SUMPRODUCT(--(YEAR($C$8:$C$23)=P1),$O$8:$O$23)


If this post helps click Yes