date range
 

I want to calculate a sumproduct within a date range but i do not know how to
set that up
my formula is


=SUMPRODUCT(--('Data 4'!$C$8:$C$6533="InAlm"),--('Data
4'!$D$8:$D$6533=A3),--(--('Data 4'!$A$8:$A$6533)(FLOOR(C2,1))))

where 'Data 4' column A is a column of dates in the mm/dd/yy hh:mm format.
C2 is a date (8/3/2008)

Right now i have it so it shows me any datesgreater than C2's date but i
want it to show me any dates less than floor(b2,1) and greater than
floor(c2,1)

date range
 

Try,

=SUMPRODUCT(('Data 4'!A9:A30C2)*('Data 4'!A9:A30<B2)*('Data 4'!C9:C30="In
ALM")*('Data 4'!D9:D30=A3))

Mike

"Bertha needs help" wrote:

I want to calculate a sumproduct within a date range but i do not know how to
set that up
my formula is


=SUMPRODUCT(--('Data 4'!$C$8:$C$6533="InAlm"),--('Data
4'!$D$8:$D$6533=A3),--(--('Data 4'!$A$8:$A$6533)(FLOOR(C2,1))))

where 'Data 4' column A is a column of dates in the mm/dd/yy hh:mm format.
C2 is a date (8/3/2008)

Right now i have it so it shows me any datesgreater than C2's date but i
want it to show me any dates less than floor(b2,1) and greater than
floor(c2,1)

date range
 

it works thank you

"Mike H" wrote:

Try,

=SUMPRODUCT(('Data 4'!A9:A30C2)*('Data 4'!A9:A30<B2)*('Data 4'!C9:C30="In
ALM")*('Data 4'!D9:D30=A3))

Mike

"Bertha needs help" wrote:

I want to calculate a sumproduct within a date range but i do not know how to
set that up
my formula is


=SUMPRODUCT(--('Data 4'!$C$8:$C$6533="InAlm"),--('Data
4'!$D$8:$D$6533=A3),--(--('Data 4'!$A$8:$A$6533)(FLOOR(C2,1))))

where 'Data 4' column A is a column of dates in the mm/dd/yy hh:mm format.
C2 is a date (8/3/2008)

Right now i have it so it shows me any datesgreater than C2's date but i
want it to show me any dates less than floor(b2,1) and greater than
floor(c2,1)

date range
 

Glad I could help

"Bertha needs help" wrote:

it works thank you

"Mike H" wrote:

Try,

=SUMPRODUCT(('Data 4'!A9:A30C2)*('Data 4'!A9:A30<B2)*('Data 4'!C9:C30="In
ALM")*('Data 4'!D9:D30=A3))

Mike

"Bertha needs help" wrote:

I want to calculate a sumproduct within a date range but i do not know how to
set that up
my formula is


=SUMPRODUCT(--('Data 4'!$C$8:$C$6533="InAlm"),--('Data
4'!$D$8:$D$6533=A3),--(--('Data 4'!$A$8:$A$6533)(FLOOR(C2,1))))

where 'Data 4' column A is a column of dates in the mm/dd/yy hh:mm format.
C2 is a date (8/3/2008)

Right now i have it so it shows me any datesgreater than C2's date but i
want it to show me any dates less than floor(b2,1) and greater than
floor(c2,1)