Counting cells with multiple selection

U

ub

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

Teethless mama

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
 
Top