Thursday, March 5, 2015

yogi_Pull Row By Row Sum Of The Value From Column L Of Data Sheet Grouped By Data And Window

             Google Spreadsheet   Post  #1909
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-05-2015
question by Thomas Wm Hayes:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/aUiaKwJexGk
Need help rewriting stand alone formula to an ArrayFormula
Link to sample file is:


The "stand alone" formula versions in Cols C, D, E, & F all work fine. However, I would like to rewrite any of these as a single ArrayFormula on Row 3. Take your pick, they all give the same results.

Cells H3:K3 are my attempts so far. As you can see, none are working correctly. Does anyone know how to craft a single formula in Row 3 to populate the correct results downward?

Any help is appreciated.


Thanks