I work at a retail company and I am having trouble creating a new worksheet that shows the information that I need!
There are 2 worksheets:
1- Summary
2- Sales
Here is what I have right now! I'm currently using this formula: =IFERROR(VLOOKUP(A2,Sales!$A$2:$D$5,3,0),0)
Summary:
Name Code Total Sold Stock
product1 12345 20 100
Product2 12410 0 100
product3 12222 30 100
product4 14123 40 100
Sales:
Name Code Sold Stock
product1 12345 20 100
product1 12345 10 100
product3 12222 30 100
product4 14123 40 100
Product3 12222 20 100
The problem with this is that on SUMMARY, the C Column is only returning the first value it encounters on the SALES worksheet. What I need for it to do is to SUM all the SOLD values according to the NAME column or the CODE column
So, is it possible to use SUMIF and VLOOKUP together? If not, is there another option?
Bookmarks