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:

https://docs.google.com/spreadsheets/d/1Wj7ccG4ahnuBbFzvPs5fTPPDM1fb-Xdkl1lW_eTEeRA/edit?usp=sharing

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