Hi,
Can someone helps me with a formula that would works? I have tried to combine sumproduct, match or sum(sumifs(, but couldn't figure out a good formula.
Column A Column B Column C Column D
1) Buy 100 white
2) Sold 20 white
3) Give 20 white
4) Sold 15 Red
I want to sum B1:C4 for cells of column A that contains "Buy" or "Give" that fits "White" in column D.
thanks
kt
Bookmarks