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