Thursday, November 17, 2011

yogi_Sum Up Attribute In Column C For Names In Column B For Specified Dates

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user robjwill said:
Google equivalent to Sumifs too big for application - Need a smaller solution!
I have 60 People that I need to keep track of credits they purchase.  I need to enter the date they they purchase the credits, their initials and the number of credits purchased.  The inputted data is as follows:
    A           B     C
1  11/15/2011  LL    10
2  11/17/2011  RW    20
3  11/15/2011  SH    20
4  11/16/2011  VF    10
5  10/1/2011   AB    20
6  10/1/2011   RW    10
....
90 8/17/2011   SH    20
I need to track the total credits purchased by all 60 people daily, counting down from the current date (using the TODAY() function), keeping a history of 3 months of credit.  The resulting summary report should look as follows:
              RW   SH   LL   VF   AB   JB   IJ .................  person60
11/17/2011    20
11/16/2011                   10
11/15/2011         20   10
...
10/1/2011     10                       20
...
8/17/2011              20

---------------------------------
following is one solution to the problem ... I have generalized in terms of number of names and number of days preceding today's date