| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Function
=SUMPRODUCT(--(YEAR(E2:E100)=2007),(D2:D100))
will sum D for year=2007 in E "JeremyH1982" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Function
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Function
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Function
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet function? | Excel Worksheet Functions | |||
| WorkSheet Function Help | Excel Worksheet Functions | |||
| WorkSheet Function Help | Excel Worksheet Functions | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
Linear Mode
