Multiple countif criteria

[Brian Keogh]

I wish to perform a COUNTIF based on two criteria. Column
A contains a region (Asia, Us, Europe), column B a
support call age in days.

I want to count all Asian calls < 90 days, all greater
than 90 but less than 120 etc

It seems COUNTIF doesn't support multiple criteria ie
COUNTIF(Region,"Asia" AND Call_Age "<90")
COUNTIF (Region,"Asia" AND Call_Age ">90" AND Call_Age
<"120)

Any pointers greatly appreciated.
Regards,
Brian Keogh

 

[Peo Sjoblom]

Try

=COUNTIF(Call_Range,">90")-COUNTIF(Call_Range,">=120")

or what might look more logical

=SUMPRODUCT(--(Call_Range>90),--(Call_Range<120))

 

[Bob Phillips]

=SUMPRODUCT((Region="Asia")*(Call_Age<90))

=SUMPRODUCT((Region="Asia")*(Call_Age>90)")*(Call_Age<120))


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)