Thursday, January 5, 2017

yogi_In Table Of Lesson Plan Compute Running Balance Of Amount Due By Student In DropDown List

Google Spreadsheet   Post  #2103
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-05-2017
question by: Lance Jacobs (NYC):
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/Z_CBHPYQUww/NDPR2NEsDAAJ
Arrayformula to track Current Balance in Transaction Register
My sheet: 

Hi everybody,
My sheet will track a piano teachers lessons and payments. My challenge is to show Current Balance as students receive lessons and make payments.

I thought it would resemble a check register, but it got complicated by the fact that she has more than one student.

I've got a working formula in Column G – It calculates the current balance by looking at previous entries, and subtracting all payments from all fees as filtered by student the student entered on that row. But it's not an arrayformula, and I know she'll want to insert rows.
Anybody got any ideas?
Lance