Good day fellas!
Is there a way I can quickly and efficiently sum column values based on a keyword from another column? In my attachment, there are product names in Column A with corresponding values on column B. I would like to know if there is a way I can sum the values in Column B based on a word that's part of Column A? I need the sum for 4 packs (keyword 6/ 4 pack) and 12 packs (keyword 2/12oz). Please see attached file.
Bookmarks