Multiple countif criteria

  • Thread starter Thread starter Brian Keogh
  • Start date Start date
B

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
 
Try

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

or what might look more logical

=SUMPRODUCT(--(Call_Range>90),--(Call_Range<120))
 
=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)
 
Back
Top