yogi_Compute SubTotals Row By Row Based On Specified Condition

                                          Google Spreadsheet   Post  #870
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 13, 2012
user ddalethess said : (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/0hF5kE-jqus)
running subtotal based on condition

Trying to subtotal hours per day, with multiple rows potentially for a day. using: =arrayformula(if((B2:B=B1),E2:E+G1,E2:E)) in my subtotal hours column row2.

This should yield the total hours (G) for the preceding line + the time (E) for the current line IF the dates (B) of the current line and the preceding line are the same.

https://docs.google.com/spreadsheet/ccc?key=0AhRhnEnKs-HwdFktaWgtM00tSzdsNGh6TlRCLTFDd0E

not quite working right. any thoughts?

thank you,

DDale

-------------------------------------------------------------------------------------------------

following is a solution to the problem: