Count pricing associated to year
If you mean date in Column C use the below for number of parts purchased in
2009
=SUM(IF(YEAR(C8:C23)=2009,1,0))
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"
If this post helps click Yes
---------------
Jacob Skaria
"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
|