Comparing Dates Range in One Column:county the number of projects

[Dohko]

Hi,

I need to county the number of projects that occured in a date range.
How do I do this?

One column has dates like (column A)
7/7/2010

And the other has one like (this is column FF)
7/7/2010 10:23



I'm using a statement like this.
=SUMPRODUCT((ccs_export!$D:$D="blabla")*(ccs_export!$E:$E<>"abc"))*(ccs_export!$FF:$FF>A3,ccs_export!$FF:$FF<A4)

Any ideas?

Thanks.

[arthurbr]

Which XL version are you using?

[NBVC]

Maybe:

=SUMPRODUCT((ccs_export!$D:$D="blabla")*(ccs_export!$E:$E<>"abc")*(ccs_export!$FF:$FF>A3)*(ccs_export !$FF:$FF<A4))

but note 2 things... whole column references are not allowed with Sumproduct in preXL2007 and also whole column references with Sumproduct in post XL2003 is very inefficient.

If you are not in XL2007 or later, condense the ranges as much as possible.

If you are in XL2007 or later use Countifs instead:

=COUNTIFS(ccs_export!$D:$D,"blabla",ccs_export!$E:$E,"<>abc",ccs_export!$FF:$FF,">"&A3,ccs_export !$FF:$FF,"<"&A4)