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     www.energyefficientbuild.com.    Apr 13, 2013
user Mark Cowhead :(https://productforums.google.com/forum/#!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:

=IF(COUNT(A32)=0,,IF(MONTH(A32)=MONTH(TODAY()),C32,))

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!

Cheers!
-m
---------------------------------------------------------------------------------------------------------------
following is a solution to the problem