Amalgamate rows

[adamuce]

Hi,

Hope you are all well.

I usually have to amalgamate quarterly data into year data.
Rows 3 to 14 are the raw data entry points. I want to end up with Row 18 to Row 24
For example:
USA Exports Commodity "A" to Canada in Q1:20 units, Q2:30 units, Q3:40 units, q4:50 units. I want to end up with one data entry which states USA to Canada Commodity A : 140 units.

Thanks in advance

http://[IMG]http://i66.tinypic.com/2m5yzix.png[/IMG]

 

[alansidman]

crosspost https://chandoo.org/forum/threads/amalgamate-rows.37109/

 

[adamuce]

crosspost https://chandoo.org/forum/threads/amalgamate-rows.37109/

Yes like Alan has said I have crossed posted (in another forum as well)

I got one answer " For Cell [E18] =SUMIFS(E$3:E$14,B$3:B$14,B18,C$3:C$14,C18,D$3:D$14,D18) and copy down "

I tried that it works. But I will have to have all the combinations done first.
I am guessing I do a pivot table to get the combos? or is there another way of doing this excercise?

 

[Fluff]

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

If you have also posted this elsewhere as suggested by

Yes like Alan has said I have crossed posted (in another forum as well)

Please provide a link to ALL sites.
Thanks

 

[adamuce]

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

If you have also posted this elsewhere as suggested by Please provide a link to ALL sites.
Thanks

Thanks didnt realise. Since Alan posted the link, I didnt want to repost the same one :D

 

[adamuce]

Just wanted to let everyone know that the answer has been solved.