Saturday, January 19, 2013

yogi_From Data In Sheet1 Compute Income For Each Office Total By Month And Between Specified Dates


                                          Google Spreadsheet  Post  #981
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 18, 2013
user david.vlk said:(http://productforums.google.com/forum/?zx=soh9zupgmep1#!category-topic/docs/spreadsheets/38atDnOdNI8)
Count incomes for each office and total them on another sheet (example sheet attached) 
https://docs.google.com/spreadsheet/ccc?key=0AkXOKcDKgvg0dE9QQlRzaDhwNDVOM05iQ3lpTEFzVFE#gid=0

Lets say I have 200 offices and 20 payments a day. I need to count incomes for each office, for all offices and for specified period (monthly, for dates selected, yearly). I can not copy and paste data for every payment added.  Every payment means a newly added row to the document.

Thank you.
---------------------------------------------------------------------------------------------------
following is a solution to the problem

Posted by at
Labels: , , ,

3 comments:

  1. David VlkJanuary 20, 2013 at 2:28 AM

    Thank you. I managed to have it working just partially. Only the left chart works. The middle works differently to your example. Right does not works. Here is a link to a document with formulas inserted. Can you please correct my mistakes there in order to make it work? Thank you.

    ReplyDelete
  2. David VlkJanuary 20, 2013 at 2:30 AM

    Here is the link: https://docs.google.com/spreadsheet/ccc?key=0AkXOKcDKgvg0dHRTV2RtNDZhUHJnQ1A4R3pZOE84Q3c

    ReplyDelete
  3. Yogi AnandJanuary 20, 2013 at 8:03 AM

    Hi David Vlk:

    I suggest you first try with the data that I have used in my blog post ... and see if you can reproduce the results I got -- once you are able to do that, you can change the data as you need to.

    So, let me know how it goes.

    Make It A Great One.
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete

Subscribe to: Post Comments (Atom)