Countif function

[Noor Abunijim]

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

 

[muddan madhu]

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 )

 

[T. Valko]

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)

 

[Mike]

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

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

in message news:[email protected]...