Sum with column AB with grouping by Name in column G --- and one step further with subs

[richtree]

Hey Guys,

I was looking for help that I think may be quicker to ask then try to go back and figure it out for a few hours.

I have two worksheets. Sheet 1 is named = Summary
Sheet 2 is named = RawData_cYTD_2014


Column G is names --- John, Bill, Larry ---

Column X is product -- apples, oranges, bananas

Column AB is quantity -- 100, 50 , 25


I would like 2 sets of results on my summary page.

#1 John --- 50
Bill --- 100
Larry --- 250

Just total quantity but if John appears 10 times in Column G (multiple records/same name) , only generate one sum response as indicating in #1 (John --- 50)



#2 John apples 25
oranges 25
bananas 25

Bill apples 25
oranges 25
bananas 25

Larry apples 25
oranges 25
bananas 25

Still only generate one result for each name, but then a second result summing by product.

This would be perfect. I would be dumping the master data each month and would like it to obviously update ....

thanks again, hopefully I was clear

[gak67]

Something like this maybe?
Fruit.xlsx

[oeldere]

I would solve that with an pivot table.

@gak67

I used your example to show the pivot table.

Thanks for that.

See the attached file.

[gak67]

Yep, should have thought of that myself.

[oeldere]

@gak67

Thanks for the reply.

Unfortuanaly no reponds from richtree.

[richtree]

thanks, I did end up figuring out solving things with multiple pivot tables, but I don't understand how to keep this updating when I dump in the new data ?

[gak67]

Click on a pivot table, then on pivot table option, refresh all