I have various descriptions in Col B and values in Col C
I want to extract Sales (could appear as Sale or Sales) and COS using Sumifs based on criteria. The criteria must only consider Sales & COS that is on the far left in Col B
eg Sales W/Sale Shirts -Criteria must only consider Sales before W/Sale
I cannot get the formula to extract all sales where sale/sales is in left in Col B
I have attached sample Data
It would be appreciated if someone could assist me
Bookmarks