I have the following formula in a cell:
=COUNTIFS(B:B,"Fred",F:F,"Green")
This produces a count of how many green apples belong to Fred. Now let's say column C contains info about where the apples were purchased ("Store", "Farm", "Market", etc.), and I'd like to count all the green apples that belong to Fred (current formula) PLUS all the red apples that belong to Fred that came from the Market, but not from the Store or Farm.
Anyone have any ideas about how to modify the COUNTIFS formula above?
Bookmarks