Thursday, November 29, 2012

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    Nov 28, 2012
user Pergas Si said:(;postID=4178660158141334476)
Question about formula (if month...)

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

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