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


"ub" wrote:

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')