I want to count the number of times the following conditions are met. I am trying to use the COUNTIFS function but I got stuck when the criteria can be any of 3 options. I don't want to count the pink apples.
Column A="Apple"
AND Column B="red" OR Column B="Yellow" OR column B="Green)
Please see attachment
Thanks
Bookmarks