yogi_Sum Values In Column G Of Sheet Realizacija/podjetja For The Month Name In Column A Of Sheet Zaslužki

                                          Google Spreadsheet   Post  #898

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 28, 2012

user Pergas Si said:(http://www.blogger.com/blogger.g?blogID=8807805591547673516#editor/target=post;postID=4178660158141334476)
Question about formula (if month...)
Hello,

I have a question about formula in google docs and this is how it goes:

In column A I have dates (1.12.2012, 22.11.2012,...) and in column D I have values which are earnings on that day. I want that in A1 on other sheet, it counts all the earnings in selected month.

Thank you

---

https://docs.google.com/spreadsheet/ccc?key=0Am4TqJJ8aHUWdG1HZ2hrV0VrNzd5d3ExaTYycGF5a2c#gid=0

Ok here is the spreadsheet. 

So in sheet "realizacija/podjetja" there is in the column A (Datum) is date and in column E there is "provizija".

In sheet "zaslužki" there is column G (provizije). I would like that this column has a formula so it gathers information from Klici!E:E based on month of the year. So SUM of E in november.

I hope you understand me...

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

following is a solution to the problem ... based on user's locale, the month names are as they would be in Slovenia