Wednesday, November 14, 2012

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.
not quite working right. any thoughts?
thank you,
DDale
-------------------------------------------------------------------------------------------------

following is a solution to the problem:

No comments:

Post a Comment