Count pricing associated to year
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
"Kassie" wrote:
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
|