On Mon, 5 Sep 2005 07:50:09 -0700, "zubee"
wrote:
Hi all,
I'm looking for the correct formula for this expression.
=COUNTIF((Your_Range,"hat and coat") or COUNTIF(Your_Range,"hat")) and
(range,"New York")
The first two criteria are possible selections and the third is a must in
order to count the record as 1
My question is what would be the logical expression(formula) to show this.
--
=--(((COUNTIF(Your_Range,"hat and coat") + COUNTIF(Your_Range,"hat")) *
COUNTIF(range,"New York")) 0)
=IF(AND(OR(COUNTIF(Your_Range,"hat and coat"),
COUNTIF(Your_Range,"hat")),COUNTIF(range,"New York")),1,0)
--ron
|