I'm trying to create a function that will count how many if one of three criteria are met in Column A and one criteria is also met in Column B.

So essentially, column A holds 6 different criteria and Column B holds much more than that (it includes different products). I need to count for one product (column B) that is in either one of three phases of the life cycle (column A).

I have scoured the web, but have come up empty-handed. Any help would be greatly appreciated.

## Bookmarks