Jeremy
=SUMPRODUCT((YEAR(E1:E6)=2007)*(D1:D6))
Adjust the range as required. Note that it cannot be a full column and the
ranges should match.
Regards
Trevor
"JeremyH1982" wrote in message
...
Hello everyone,
This is what I would like to do...
Column E contains dates, that the order has been taken.
Column D contains the pairs that were sold.
I would like to add up just the orders that were sold in 07, in comparison
to 06.
What formula would I use??
I'm assuming it's an IF statement. If the order wasn't placed in 07, i
don't
want them to be in the total.
--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com