Hello Everyone, Can someone help me with this.
Lets say in column "A" i have item numbers for products that i sell, and in column "C" and "D" i have the amount sold for each product. One of these products named "Big Deal" has four (4) item numbers, the item numbers are (101,155,165 & 200) I now need a formula that will look for these item numbers in colum "A" and then sum or total the amount sold for this item.
I tried this formula but its not working: Sumif(A1:D7,(vlookup{101,155,165,200},A1:D7,{3,4},0)),(A1:A7))
Column Column Column Column
A B C D
Row# Item# Product Sold Sold
1. 101 Big Deal 15 20
2. 107 Star Meal 9 10
3. 112 Hot Wings 22 50
4. 150 Popcorn 33 75
5. 155 Big Deal 70 65
6. 165 Big Deal 90 80
7. 200 Big Deal 20 12
Sumif(A1:D7,(vlookup{101,155,165,200},A1:D7,{3,4},0)),(A1:A7))
Bookmarks