Thursday, September 13, 2012

yogi_Compute Dynamic Group Total In Another Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #745   Sep 14, 2012

user coderwolf said: (!category-topic/docs/spreadsheets/9q9OzbtTaSQ)
dynamic group totaling 
Given a spreadsheet with the following columns: Description, Catagory, Qty Owned, Unit Price.  How can I have a column on a different sheet that will sum all extended prices for the category listed?
following is a bit more generalized solution to the problem wherein I have computed totals for group of all and select categories by category as well as for the entire group