Countif using more than one criteria.

Shayne · Oct 15, 2004

Hello

I am trying to create a function that will read a range of dates that
greater than one date and lesser than another date and return the total
number. I have tried the countif function without success. Any suggestions?

Frank Kabel · Oct 15, 2004

Hi
use SUMPRODUCT. see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

Shayne said:
Hello

I am trying to create a function that will read a range of dates that
greater than one date and lesser than another date and return the total
number. I have tried the countif function without success. Any

suggestions?

Aladin Akyurek · Oct 15, 2004

=COUNTIF(DateRange,">"&E2)-COUNTIF(DateRange,">="&F2)

where E2 houses a true date and F2 another true date with E2 <= F2.

Shayne · Oct 16, 2004

Thank you very much...it works great.

Shayne

Aladin Akyurek said:
=COUNTIF(DateRange,">"&E2)-COUNTIF(DateRange,">="&F2)

where E2 houses a true date and F2 another true date with E2 <= F2.