select date range in column

[Biff]

Hi!

Try this:

D1 = start date
E1 = end date

Sum values in column B where the corresponding dates in column A fall within
the date range (inclusive):

=SUMIF(A1:A20,">="&D1,B1:B20)-SUMIF(A1:A20,">"&E1,B1:B20)

Or:

=SUMPRODUCT(--(A1:A20>=D1),--(A1:A20<=E1),B1:B20)

Biff

"garlocd" <garlocd@discussions.microsoft.com> wrote in message
news:21AD3160-B913-4397-97AE-1413F1A839DC@microsoft.com...
>I need to be able to sum one column based on dates in another column.
>
> Thankful for any help on this.

[Max]

"garlocd" wrote:
> I need to be able to sum one column based on dates in another column.

One way ..

Assuming real dates are within $A$2:$A$100,
with values to be summed in $B$2:$B$100

Try something like this in say, C1:
=SUMPRODUCT(($A$2:$A$100>= -- "1-Jun-2006")*($A$2:$A$100<= --
"15-Jun-2006"),$B$2:$B$100)

Adapt to suit, but note that entire col references eg: A:A, B:B, cannot be
used in SUMPRODUCT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[garlocd]

I need to be able to sum one column based on dates in another column.

Thankful for any help on this.

[Biff]

Hi!

Try this:

D1 = start date
E1 = end date

Sum values in column B where the corresponding dates in column A fall within
the date range (inclusive):

=SUMIF(A1:A20,">="&D1,B1:B20)-SUMIF(A1:A20,">"&E1,B1:B20)

Or:

=SUMPRODUCT(--(A1:A20>=D1),--(A1:A20<=E1),B1:B20)

Biff

"garlocd" <garlocd@discussions.microsoft.com> wrote in message
news:21AD3160-B913-4397-97AE-1413F1A839DC@microsoft.com...
>I need to be able to sum one column based on dates in another column.
>
> Thankful for any help on this.

[Max]

"garlocd" wrote:
> I need to be able to sum one column based on dates in another column.

One way ..

Assuming real dates are within $A$2:$A$100,
with values to be summed in $B$2:$B$100

Try something like this in say, C1:
=SUMPRODUCT(($A$2:$A$100>= -- "1-Jun-2006")*($A$2:$A$100<= --
"15-Jun-2006"),$B$2:$B$100)

Adapt to suit, but note that entire col references eg: A:A, B:B, cannot be
used in SUMPRODUCT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---