Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #795 Oct 09, 2012 www.energyefficientbuild.com.
user UnreasonableMan said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/aHQL2-GzUJ8)
A Single Arrayformula to Sum a Filter of All Rows
This is a link to a simplified version of the spreadsheet I'm trying to build.
user UnreasonableMan said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/aHQL2-GzUJ8)
A Single Arrayformula to Sum a Filter of All Rows
This is a link to a simplified version of the spreadsheet I'm trying to build.
On the Summary sheet, I have filter formulas in columns B and C to sum the quantities from the Data sheet that meet two criteria.
The real spreadsheet is more complicated, and I would like to reduce the number of formulas to speed it up and make it more efficient. Can I replace the filter formulas with one arrayformula per column (or is there a better option)?
---------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem but a slightly different output than expected by the user
No comments:
Post a Comment