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   Mar-05-2015
question by Thomas Wm Hayes:!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.