sumifs question

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 or sumifs, it will either calculate item 2 and item 6 twice, or it will only calculate if color string contains "Blue&Yellow&white", how do I use sumifs correctly, so it will count unique row only once?

anyone can help?

thanks

[ deleted by me ]

I noticed Excel version - 2007