So.. im stuck. Mainly due to my newbie skills.
For easy usage, i need to use Sumproduct (or something else) to sum up a column of numbers. However, i want the formula to find the corresponding Store Name before doing the sum. It also has a restriction to only sum value if Cell A contains a specific word.
see the file attached. its easier.
its probably an easy formula. But im stuck
example.xlsx
Bookmarks