I have some trouble using sum and sumifs, I have data similar to below,
items Name Color free cost
item 1 red, blue, yellow Y 100
Item 2 blue, yellow,black, white Y 50
Item 3 red, yellow N 20
Item 4 green, N 12
item 5 green, red, blue, Y 22
item 6 White, red Y 24
Now I wanted to find "color" contains "blue or yellow or white", AND free = Y, then sum up these items cost,
but no matter how I use sum of sumif, it will either calculate item 2 and item 6 twice, or it will only calculate if color string contains "Blue&Yellow&white"
anyone can help?
thanks
Bookmarks