date range

[Bertha needs help]

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)

 

[Mike H]

Try,

=SUMPRODUCT(('Data 4'!A9:A30>C2)*('Data 4'!A9:A30<B2)*('Data 4'!C9:C30="In
ALM")*('Data 4'!D930=A3))

Mike

 

[Bertha needs help]

it works thank you

Try,

=SUMPRODUCT(('Data 4'!A9:A30>C2)*('Data 4'!A9:A30<B2)*('Data 4'!C9:C30="In
ALM")*('Data 4'!D930=A3))

Mike

 

[Mike H]

Glad I could help

it works thank you