how do i create a formula that still uses sumproduct but excludes data if it contains a text in a separate column?
ex: looking for data that fits the criteria apples, oranges, grapes, bananas, but in a separate column, if it's the color yellow for any of my criteria's then i want to exclude its total.
hopefully this makes sense.
ex: looking for data that fits the criteria apples, oranges, grapes, bananas, but in a separate column, if it's the color yellow for any of my criteria's then i want to exclude its total.
hopefully this makes sense.