Thursday, February 6, 2014

yogi_Compute Total Credit For Customers From Table Of Name Credit And Date In Another Tab

                                         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
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 

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

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