I want to sum all the sales for the same ASIN from "Business Report by Child ASIN" "column M" in 1 cell in the Profit and Loss tab.
Business Report by Child ASIN have multiple time same ASIN with different sales volume
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Excel Vlookup for multiple values found
0
Discussion
Hello, @Variatus Thank you so much, it worked out and looks great! I get the results I wanted.
yaseen381 (rep: 2) Jul 8, '21 at 8:15 pm
Answers
0
Selected Answer
Hello Yaseen,
You can do that with a SUMIF function. Personally, I prefer the SUMIFS function which has the same syntax for a single or multiple conditions. Fewer things to learn :-)
[B2] =SUMIFS('Business Report by Child ASIN'!M:M,'Business Report by Child ASIN'!B:B,A2)[C2] =SUMIFS('Business Report by Child ASIN'!O:O,'Business Report by Child ASIN'!B:B,A2)If you feel that the range references, like 'Business Report by Child ASIN'!M:M, are unwieldy, look into named ranges to replace them with shorter and descriptive names, for example "ChildSales".