yogi_Compute Row By Row Monthly Sum Where Dates Are In Column A And Column C contains 'Juro' or 'BACEN'

                                         Google Spreadsheet   Post  #1534
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-16-2014
post by ranthegreat (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/FR_s8L0q0P0)
Sum values in a column according to criteria in more than 1 column without sumifs

Hello all,

I'd like to sum the values in a column (G) where B4:B has dates (need to sum values by month!) AND text in column D4:D has the text "Juros" OR "BACEN".

I don't know how to use arrayFormula, and I don't think it will help.

Also, the form is not updated to the latest version, so, using SUMIFS is out of the question.

Here's the sheet

https://docs.google.com/spreadsheet/ccc?key=0AngsaEYmwihkdGZ1ekYzdWVZcEszUGlwSTBSVTVJS0E&usp=sharing

----------------------------------------------------------------------------------------------------------------------------------------

I noticed that in your spreadsheet dates are in column A and it is column C that is upposed to contain either 'Juros' or BACEN'