countif using two conditions

[NWO]

Hello.

I read all of the COUNTIF , AND threads but did not find a solution to my
problem.

- I have a column of dates on one worklsheet
- I'm trying to do a countif when the date falls between 2 dates that I
specify,
something like
COUNTif(sheet1!A:A,">=05/15/2009)+COUNTIF(sheet1!A:A,"<=5/21/2009), not no
luck.

Any assitance is welcome.

 

[Max]

Try SUMPRODUCT
Something like this (using unambiguous date range criteria):
=SUMPRODUCT((Sheet1!A2:A10>=--"15 May 2009")*(Sheet1!A2:A10<=--"21 May 2009"))
should work fine for you. Adapt the ranges/criteria to suit.
High five success by clicking the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik