Google Spreadsheet Post #1519
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-06-2014
post by Robert Hollingsworth (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2Cnj4eguoxQ)
Total of multiple value
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-06-2014
post by Robert Hollingsworth (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2Cnj4eguoxQ)
Total of multiple value
I have a list of credits due to clients on one TAB, I want to have a Tab with a summary adding all credits due to clients as a total.
Name Total Credit
Mr Smith
Mr Brown
Mr Green
Mr Smith
Mr Brown
Mr Green
In Tab One
Customer credit due date
Mr Smith -1.98 1/2/2014
Mr Smith -10.5 1/2/2014
Mr Smith -47.42 2/2/2014
Mr Brown -26.25 1/2/2014
Mr Brown -24 1/2/2014
Mr Brown -38.03 1/2/2014
Mr Brown -27.96 2/2/2014
Mr Brown -15 1/2/2014
Mr Brown -15 1/2/2014
Mr Green -15 2/2/2014
Mr Green -25 2/2/2014
Mr Green -75 2/2/2014
Mr Green -16 1/2/2014
Mr Green -5 1/2/2014
Mr Green -50 1/2/2014
Mr Smith -1.98 1/2/2014
Mr Smith -10.5 1/2/2014
Mr Smith -47.42 2/2/2014
Mr Brown -26.25 1/2/2014
Mr Brown -24 1/2/2014
Mr Brown -38.03 1/2/2014
Mr Brown -27.96 2/2/2014
Mr Brown -15 1/2/2014
Mr Brown -15 1/2/2014
Mr Green -15 2/2/2014
Mr Green -25 2/2/2014
Mr Green -75 2/2/2014
Mr Green -16 1/2/2014
Mr Green -5 1/2/2014
Mr Green -50 1/2/2014
In TAB Two
The dates are irrelevant, I just want a total of all credits due to show in TAB one, I have tried a Vlookup; however that only returns the first value, I need all as a total.
Regards
Robert
----------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment