Hi,
Need a solution for the following please;
1. Search a product from a product list a-z in a product tab
2. Find all sales for this product in the Sales Tab in the same sheet.
3. Sales for products have multiple entries (quantities) in columns E, H, K, N, Q...etc every 3rd column.
4 Add all sales by product and return a total next to the product in the product tab.
Ive tried SUMIF and sum(VLOOKUP) but cant get a solution.
Hoep someone can assist please!
Thanks
Peter
Need a solution for the following please;
1. Search a product from a product list a-z in a product tab
2. Find all sales for this product in the Sales Tab in the same sheet.
3. Sales for products have multiple entries (quantities) in columns E, H, K, N, Q...etc every 3rd column.
4 Add all sales by product and return a total next to the product in the product tab.
Ive tried SUMIF and sum(VLOOKUP) but cant get a solution.
Hoep someone can assist please!
Thanks
Peter