With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
question by: Marc Zaldivar
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/sVyYglkxraI;context-place=forum/docs Trying to set up multiple conditions with SUMIF or DSUM?
I'm have a form that collects payments by different categories. I'd like to create another sheet that shows sums for each of the categories within a certain date range.
For instance, Sheet1:Column A is Payee. Sheet1:Column B is Date. Sheet1:Column C is Amount. Sheet4: Column D is Category (let's say, CatA, CatB, CatC).
On Sheet 2, I'd like to sum any amounts that are between 5/1/2018 and 5/31/2018 in CatA on one row, CatB on another.
I assume I need nested IF statements or a DSUM, but I keep getting an error.