Dear Sir'

I have below excell sheet :
Bus ID Company Name Bus Location

1 Asia Operational
2 CMTC Marka
3 Thilal Operational
4 Asia Operational

i need to count hoew mwny buses from (Asia) company is in (Operational) location .

I need your quick reply ;

Thanks and Regards;
Noor

assuned company names are in col B and bus location in col C

=COUNT(IF((B2:B10="asia")*(C2:C10="operational"),) ) ( use ctrl +
shift + enter )



On Nov 30, 11:09*pm, Noor Abunijim wrote:
Dear Sir'

I have below excell sheet :
Bus ID * Company Name * * Bus Location

1 * * * *Asia * * * * * * *Operational
2 * * * *CMTC * * * * * * * Marka
3 * * * *Thilal * * * * * * Operational
4 * * * *Asia * * * * * * * Operational

i need to count hoew mwny buses from (Asia) company is in (Operational) location .

I need your quick reply ;

Thanks and Regards;
Noor

Try this:

=SUMPRODUCT(--(B1:B4="Asia"),--(C1:C4="Operational"))

Better to use cells to hold the criteria:

E1 = Asia
F1 = Operational

=SUMPRODUCT(--(B1:B4=E1),--(C1:C4=F1))

If you're using Excel 2007:

=COUNTIFS(B1:B4,E1,C1:C4,F1)

--
Biff
Microsoft Excel MVP


<Noor Abunijim wrote in message ...
Dear Sir'

I have below excell sheet :
Bus ID Company Name Bus Location

1 Asia Operational
2 CMTC Marka
3 Thilal Operational
4 Asia Operational

i need to count hoew mwny buses from (Asia) company is in (Operational)
location .

I need your quick reply ;

Thanks and Regards;
Noor

Try this
=SUMPRODUCT(--(B2:B5="Asia")*(C2:C5="Operational"))

"Noor Abunijim" wrote:

Dear Sir'

I have below excell sheet :
Bus ID Company Name Bus Location

1 Asia Operational
2 CMTC Marka
3 Thilal Operational
4 Asia Operational

i need to count hoew mwny buses from (Asia) company is in (Operational) location .

I need your quick reply ;

Thanks and Regards;
Noor

Hi,

In addition to using SUMPRODUCT() and COUNTIF(), you can also work with
pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Noor Abunijim" wrote in message ...
Dear Sir'

I have below excell sheet :
Bus ID Company Name Bus Location

1 Asia Operational
2 CMTC Marka
3 Thilal Operational
4 Asia Operational

i need to count hoew mwny buses from (Asia) company is in (Operational)
location .

I need your quick reply ;

Thanks and Regards;
Noor