So I'm preparing a Sales Budget Template.
I need an array formula to Total (sum all the QTY by the price of Each product for ALL Stores for every month) (Need Formula for GREEN CELL) on sample sheet.
Note: Not all prices for the same item are the same.
There are more than 100 stores with the same 5 items. Attached for reference I only put 5 Stores.
Thank you!
M.A.
Bookmarks