Hey there party people,
This seems to be a question asked about before, however, no clear-cut answer solves my puzzle. I've tried variations of sumif and countif functions. Please let me know what you got.
My document is like this:
A B
123ABC 1000
123ABC 1500
456DEF 450
789GHI 500
I just want to get a new sheet that says:
A B
123ABC 2500
456DEF 450
789GHI 500
Please and thank you.
Have you considered a Pivot Table. That will give you the results you seek.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
SUMIF() will get you individual results.
To quickly and easily summarize an entire table, make sure row 1 has "titles" and then apply a Pivot table.
Pivot video: https://www.screencast.com/t/vGerfUHg
Last edited by JBeaucaire; 02-01-2017 at 06:38 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Have you considered a Pivot Table. That will give you the results you seek.
Here's another one...
Data on Sheet1...
Sheet1
On Sheet2...
Sheet2
This array formula** entered in A2:
=IFERROR(INDEX(Sheet1!A$2:A$5,MATCH(0,COUNTIF(A$1:A1,Sheet1!A$2:A$5),0)),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
This formula entered in B2:
=IF(A2="","",SUMIF(Sheet1!A:A,A2,Sheet1!B:B))
Select A2:B2 and copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks