I am struggling with the formula. I need to pull the info from all the cells that contain the "ITEM" and give me the total number. Some cells have multiple items, so when i use the COUNTIFS formula it does not pull the info from the cells with multiple items in it. What formula should I use? I need to take into account e.g. ITEM and COLOR.
Help Article Resources
Check out the Formula Handbook template!