I need a formula that will count the values in column B if the values in collumn A say a certain word. For example i have three order types - urgent, plan and stock (collumn A) and i need to count the number of orders of each type. Collumn B has the order numbers. Additionally the order numbers may be duplicated so i only need to count the individual numbers. I found a sum if freq formula but this counts without looking to see whats in collumn A. Can anyone help with this?