date range

  • Thread starter Thread starter Bertha needs help
  • Start date Start date
B

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)
 
Try,

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

Mike
 
Back
Top