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     www.energyefficientbuild.com.

user coderwolf said: (http://productforums.google.com/forum/?zx=xlo0lp3l8ecl#!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

No comments:

Post a Comment