Help needed...

[Jokacave]

Hi,
I am looking for help on a file i am working on...

A B C
Date IN OUT
01/01/06 12 2
03/01/06 3 8
05/01/06 8 0
09/01/06 10 4
15/01/06
...

And I need a formula in D1 to get the total of data in column B between 01/01/06 and 07/01/06, in D2 to get the total of data in column B between 08/01/06 and 14/01/06, etc.

Can someone please help me with this? Thanks in advance.

[SteveG]

Hi,

Try something like,

=SUMPRODUCT(--($A$2:$A$5>=DATEVALUE("1/1/2006")),--($A$2:$A$5<=DATEVALUE("1/7/2006")),($B$2:$B$5))

Note: The ranges used must be equal in length and cannot be entire column references i.e. A:A or B:B.

HTH

Steve

[Jokacave]

Hi, SteveG

It works...

Thank you for your help.

[SteveG]

Glad I could help.

Cheers,

Steve