I need to add all the data in columns B for all instances of a value occuring in column A
For eg
ColumnA Column B
Apple 4
Apple 5
Orange 3
Orange 5
Mango 2
Lemon 1
Lemon 9
I want the final result to look like this
ColumnA Column B
Apple 9
Orange 8
Mango 2
Lemon 10
Please help!
Thanks
Welcome to the forum,
This is a Cross Post
Please read the rules you agreed to. Rule 16 clearly spells out what you agreed to in terms of Cross Posting. After you have done so please ClickHere and Private Message me or one of the other Moderators: royUK;Jack in the UK;Richie(UK);Dave Hawley;ByTheCringe2 with your acceptance, or non-acceptance of the rules. Please also include a link to this Thread. You can copy this directly from the Address bar of your Browser. When this is done your thread will be re-opened.
Re: Sum Values For One Column According To The Values In Another Column?
PM Received rules accepted. Thread re-opened.
Re: Sum Values For One Column According To The Values In Another Column?
I just wanted to quickly add that the problem I have with the SUMIF function is that I have way too many values in columnA and that makes it difficult for me to individually specify the criteria. Is there anyway Excel can automatically sum up the values in column B for all recurrring instances in column A? I noticed i some previous responses that a Pivot table can be used. I have never heard of it or used it before. So please help!!
Thanks!
Re: Sum Values For One Column According To The Values In Another Column?
see;
Five ways to subtotal values in repeating data
and take your choice.
p45cal
Re: Sum Values For One Column According To The Values In Another Column?
See PivotTables
Don’t have an account yet? Register yourself now and be a part of our community!
