Monday, May 27, 2013

yogi_MultiConditional Sum Involving Dates Entered As TEXT

                                          Google Spreadsheet   Post  #1214
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 27, 2013
user wetabax (http://productforums.google.com/forum/?zx=qauj613l7zna#!category-topic/docs/spreadsheets/ZotKtEcevQo)
problem with function SUM together with FILTER
It seems that Google Docs doesn't offer the SUMIFS function. Instead, it was suggested to use a workaround combining SUM with FILTER
I'm trying to sum values filtering months in a specific year.
I've created a formula like this: =sum(FILTER(H:H,A:A>="01/02/2013",A:A<="28/02/2013")) but something must be wrong, I have an error message.
H = values A = dates
I made another test, creating two cells with the dates. E.g. cell L3 with the date 01/02/2013, and cell M3 with the date 28/02/2013
Formula used is: =sum(FILTER(H:H,A:A,">="&L3,"<="&M3)) - Didn't work as well.
Can anybody find what is wrong in it? (the DD/MM/YYYY is setted as correct = portuguese language - so it's not MM/DD/YYYY).
thanks.
I've shared by link the Spreadsheet, only for view, if necessary.
------------------------------------------------------------------------------------------------------------------------------
date formats available in Portugese are YYYY-MM-DD or YY-MM-DD ... so to key-in dates in DD/MM/YYYY format I used date entries as TEXT in DD/MM/YYYY format