Countif function

  • Thread starter Thread starter Noor Abunijim
  • Start date Start date
N

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
 
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 )
 
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)
 
Back
Top