Counting cells with multiple selection

[Guest]

Hi,
How Can I have multiple condition using countif function
Can we use the Countif function or any other function if we are
working with dates or strings.
Ex: to count cells between 2 set of dates or to count cells that match
string('sale' or 'quote')

 

[Guest]

Look at SUMPRODUCT

See

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Guest]

Count how many days between Jan 1 to Jan 10

=COUNTIF(B1:B100,">="&--"1/1/2007")-COUNTIF(B1:B100,">"&--"1/10/2007")

Count sale or quote

=SUM(COUNTIF(A1:A100,{"sale","quote"}))

Adjust to suit