Hi
I want to how to write a formula in cell x(see below table) to show the number of blue color product if the condition of the product is good.
<tbody>
</tbody>
Many thanks
I want to how to write a formula in cell x(see below table) to show the number of blue color product if the condition of the product is good.
Product Condition | Product Color | X | ||
good | blue | |||
bad | yellow | |||
bad | blue | |||
good | blue | |||
good | blue | |||
bad | red | |||
good | pink | |||
bad | blue | |||
<tbody>
</tbody>
Many thanks