=SUMPRODUCT(--(B1:B100="HMO"),--(C1:C100="EPO"))
Commit with a simple ENTER (it is not an array formula)
You cannot use whole columns (B:B)
For more info see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alex" wrote in message
...
In Col A i need formula to count how many HMOs in Col B have EPO in Col C
Col A Col B Col C
1 HMO EPO
HMO UFO
PPO ADP
CEO EOP
HOM TLC
PPO EPO