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
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