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
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
Yogi,
ReplyDeleteWhen I enter the transpose formula for cell F1,
=transpose(query(unique(B3:B),"select Col1 where Col1<>" ")),
I get the error "Make sure your formula has matching quotes". I tried =transpose(query(unique(B3:B),"select Col1 where Col1"<>" ")) but then I get #VALUE!......
What do I need to do?
Yogi,
ReplyDeleteHere is the link to my actual spreadsheet. I can't get the ArrayFormula formula to work...
https://docs.google.com/spreadsheet/ccc?key=0Agcb8bUVVOOodEhzeEI1N0pkbExFbnJ1cEY0SFZpV1E