Hello, I am trying to make a list of same rows and add up quantities.
If Collumns H:K match, then add collumn D row values and paste result to Sheet "Total".
I tried using Sumif function with unique, did not get wanted result.
Can you help me with this?
EXAMPLE01.png
Last edited by windzz; 10-14-2021 at 05:32 AM.
Administrative Note
Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
What do you mean, AliGW, did I do something wrong by asking for help?
Not at all.
Your opening post mentions UNIQUE, which was not available in Excel 2010, therefore your forum profile is out of date. I am asking you to update it with your latest version, please.
When you have done this, please provide a copy of the workbook that shows manually calculated results so that we can see what you are aiming for.
I have updated my info.
UNIQUE function was proposal. I don't have anything at this moment. I am trying to get some opinions which functions and methods could work at least.
I hope I explained in the topic what I am trying to do enough?
The thing is, that there are collumns H:K , which act as a criteria for dublicate. If one row matches with other row, by all of the collumn (exactly), then it add values of the collumn D together.
Maybe this can only be done with Macro?
Please fill in three rows of expected result data MANUALLY in the workbook to SHOW us what you are aiming for. No need for formulae - we will do that bit.
If you have access to the UNIQUE function, then your Excel version must be either Excel 2021 or MS365, so I am not sure that 2019 is accurate.
Hello, I am using Excel 2019, i don't have access to UNIQUE function, i just googled it that it does similar result, but my version of excel does not support it.
I have updated the attached excel
Attachment 751594
Try pasting the following into cell D2 and copying down on the Total sheet of the file attached to post #1:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks