Saturday, April 13, 2013

yogi_In A Table Of Expenses By Date Automate Filling-In Of Day By Day Day Expenses For Current Month

                                          Google Spreadsheet   Post  #1121
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 13, 2013
user Mark Cowhead :(!category-topic/docs/spreadsheets/wusCv0yhiCk)
Help with ArrayFormula.... (I think?)
99% percent of the time I like to figure things out on my own, but ArrayFormula has me stumped!

Basically, I have this nifty formula that I wrote for a finances spreadsheet. I would like it to automatically populate a certain column whenever new rows are added so I don't have to manually fill the fields whenever I add new data. As I understand it, this is exactly what Array formula is for, but I have utterly failed to figure out how to make it work. I'm not a total n00b when it comes to spreadsheets, but this is entirely new territory for me and I could use some help

Here's what I got:


The idea is, I want to calculate how much money I've spent on bills this month and this month only. I want this column, column "E" (which will be hidden once I get it working...), to contain the values from column "C," but only if there is a date in column A, and that date is from the current month.

Here's a copy of the spreadsheet...feel free to do with it as you will!

Thanks in advance for any and all assistance that may be provided!

following is a solution to the problem