Tuesday, October 9, 2012

yogi_Setup A CrossTab For Sale Quantities To Different Entities By Year And Month

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.  


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