Did you try the formula? It will sum all entries for 2007 like you stated in
your OP, do the same for 2006 and you'll get your comparison
--
Regards,
Peo Sjoblom
"JeremyH1982" wrote in message
...
That would work... but the dates are different, it's not all the same
format...
examples: one order could be dated 09/20/07, another one could be 4/27/07
--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com
"Toppers" wrote:
=SUMPRODUCT(--(YEAR(E2:E100)=2007),(D2:D100))
will sum D for year=2007 in E