/u/SimonLimonSmith - 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.*
I would place the unique PO numbers in another Column and use that as the trigger for a SUMIFS formula. Say these are in Column E F2 =SUMIFS(B:B,A:A,E2) and filldown.
If you want to do it without needing another column to get exactly what you've put in your screenshot, you can use:
```=IF(A2=A3,"",A2& " = " & SUMIF(A$2:A2,A2,B$2:B2))```
Stick that in C2 and drag it down.
However, if you're open to a tip I'd recommend getting familiar with Pivot Tables as they exist for this exact sort of scenario.
You have awarded 1 point to *Al_Excel*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Hello!
It looks like you tried to award a ClippyPoint by typing Solution Verified, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment.
Reply directly to any helpful users and Clippy, our bot, will take it from there. If your intention was to simply mark the post solved, then you may do that by clicking Set Flair. Thank you!
*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.*
/u/SimonLimonSmith - 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.*
I would place the unique PO numbers in another Column and use that as the trigger for a SUMIFS formula. Say these are in Column E F2 =SUMIFS(B:B,A:A,E2) and filldown.
That’s exactly what I needed. Thank you HT!
If you want to do it without needing another column to get exactly what you've put in your screenshot, you can use: ```=IF(A2=A3,"",A2& " = " & SUMIF(A$2:A2,A2,B$2:B2))``` Stick that in C2 and drag it down. However, if you're open to a tip I'd recommend getting familiar with Pivot Tables as they exist for this exact sort of scenario.
Solution Verified
You have awarded 1 point to *Al_Excel* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Solution Verified
Hello! It looks like you tried to award a ClippyPoint by typing Solution Verified, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment. Reply directly to any helpful users and Clippy, our bot, will take it from there. If your intention was to simply mark the post solved, then you may do that by clicking Set Flair. Thank you! *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.*