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

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

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

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

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