View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JeremyH1982 JeremyH1982 is offline
external usenet poster
 
Posts: 18
Default Worksheet Function

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