Monday, May 25, 2015

yogi_Compute Sum of In And Out By Date From Table Of Transactions In Columns H Through K

                                           Google Spreadsheet   Post  #1964
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    May 25, 2015
question  by Josh Kaye:!mydiscussions/docs/4W9DVjuDBV8
For looping natively in Sheets or a Compare/Match function
I'm trying to create a google doc to track finances over time. 

Basically I want to sum all entries from a certain date into a separate single entry of a corresponding date. The issue is that I don't know ahead of time how many entries there will be for a certain date. 

Here's what I have

So basically for 6/9/2015 in A, I want to sum all the values in G where the corresponding H value is 6/9/2015 and then put that sum into the D cell in the same row as the original A. 
Basically this behemoth for C7:
Except that I have several categories beyond food and many rows to contend with. I had hoped that there was something resembling a for loop like one might use in java to go through the relevant columns and compare but I don't know of a way to do that natively in docs.
Is there a way to implement this without getting into writing my own script?
Thanks very much in advance.