counting a range

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

hi
i have the following formula that counts a range depending on the date

SUMPRODUCT(--(TEXT($A$1:$A$350,"dd-mm")=TEXT(AA1,"dd-mm")),$E$1:$E$350)
AA1 = 01-03-2004
dates 01-03

this returns a value for all the date range
i need to refine this further to count between to date values ie one weeks
values
ie 01-03-04 to 07-03-04
08-03-04 to 15-03-04

thanks in advance

kevin
 
Hi
try
=SUMPRODUCT(($A$1:$A$350>=DATE(2004,3,1))*($A$1:$A$350<=DATE(2004,3,7))
,$E$1:$E$350)
 
Back
Top