Say you want to calclate prices for items purchased in the year as indicated
in C11, then use =SUMIF(C8:O23,C11,O8:O23). Obviously, changing C11 to C
whatever, will change the result, it the other cell contains a different year.

--
HTH

Kassie

Replace xxx with hotmail


"Neall" wrote:

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