Countif using more than one criteria.

[Guest]

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]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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]

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

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

 

[Guest]

Thank you very much...it works great.

Shayne

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

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