Hello,

I have looked through the threads and believe what I require is the
SUMPRODUCT function.

I have a spreadsheet with column A containing dates in the format
dd/mm/yyyy and column B containing values.

What formula should I use in column C that will add up all deals
between two dates?

Eg between 01/01/2004 and 15/01/2005 ?

TIA for your help.

Ket
London

Hi

something like this:
=SUMPRODUCT(--(A2:A100=DATE(2004,1,1)),--(A2:A100<=DATE(2005,1,15)),B2:B100
)

NB! You can't use references like 'A:A' with SUMPRODUCT - the ranges must be
exactly defined, and all of same dimension.


Arvi Laanemets

"Ket" wrote in message
...
Hello,

I have looked through the threads and believe what I require is the
SUMPRODUCT function.

I have a spreadsheet with column A containing dates in the format
dd/mm/yyyy and column B containing values.

What formula should I use in column C that will add up all deals
between two dates?

Eg between 01/01/2004 and 15/01/2005 ?

TIA for your help.

Ket
London

Sumproduct is not actually required for this.


=Sumif(A:A,"=01/01/2004",B:B) - Sumif(A:A,"15/01/2005",B:B)

--
Regards,
Tom Ogilvy



"Ket" wrote in message
...
Hello,

I have looked through the threads and believe what I require is the
SUMPRODUCT function.

I have a spreadsheet with column A containing dates in the format
dd/mm/yyyy and column B containing values.

What formula should I use in column C that will add up all deals
between two dates?

Eg between 01/01/2004 and 15/01/2005 ?

TIA for your help.

Ket
London

You can use two SUMIF formulas:


=SUMIF(A1:A100,"="&DATE(2004,1,1),C1:C100)-SUMIF(A1:A100,""&DATE(2005,1,15),C1:C100)


On Mon, 21 Feb 2005 17:48:52 +0000, Ket wrote:

Hello,

I have looked through the threads and believe what I require is the
SUMPRODUCT function.

I have a spreadsheet with column A containing dates in the format
dd/mm/yyyy and column B containing values.

What formula should I use in column C that will add up all deals
between two dates?

Eg between 01/01/2004 and 15/01/2005 ?

TIA for your help.

Ket
London