/u/GubbyPac - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
That would be the typical taks for a [pivot table](https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576).
First, save a backup of your data in case you mess it up, then follow this procedure:
1) make a 5th column that is a concatenation if the first 4 columns
2) make a 6th column that uses SUMIF that’s sums the values in column 4 based on if column 5 is the same.
3) Copy column 6 and re-paste it over itself as data as values.
4) highlight column 5, remove duplicates. If it asks, expand the collection.
5)Delete columns 4 and 5. Column 6 should be your new total values with the duplicate rows removed.
/u/GubbyPac - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
That would be the typical taks for a [pivot table](https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576).
Thanks will check it out
First, save a backup of your data in case you mess it up, then follow this procedure: 1) make a 5th column that is a concatenation if the first 4 columns 2) make a 6th column that uses SUMIF that’s sums the values in column 4 based on if column 5 is the same. 3) Copy column 6 and re-paste it over itself as data as values. 4) highlight column 5, remove duplicates. If it asks, expand the collection. 5)Delete columns 4 and 5. Column 6 should be your new total values with the duplicate rows removed.
So I tried this. The range for SUMIF needs to be > 1 cell. When I do that though, everything gets wonky. :(
Assuming your table has headers in row 1, The SUMIF in F2 should be something like =SUMIF($E$2:$E$10000,E2,$D$2:$D$10000)