Friday, May 16, 2014

yogi_Sum Specified Attribute Values For Specific Invoice By Pulling Data From Multiple Lines In A Single Cell


                                         Google Spreadsheet   Post  #1639
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-16-2014
post by AndrewGrant: (https://productforums.google.com/forum/#!mydiscussions/docs/bx8jDdZvMcI)
Splitting and Summing Cell Data
Hello all,

I have a cell that looks like the one below. These are all the line items from an invoice. I'd like to calculate the total number of times on that invoice for a given category (Fee Income or Expenses). What I'm attempting to do is calculate the sum of the UNIT AMOUNT line for the AccountCode 12300.

AccountCode: 45400
Description: Legal Fees
LineAmount: 100.00
Quantity: 1.0000
TaxAmount: 0.00
TaxType: NONEUnitAmount: 100.00
AccountCode: 45400
Description: More Legal Fees
LineAmount: 200.00
Quantity: 1.0000
TaxAmount: 0.00
TaxType: NONEUnitAmount: 200.00
AccountCode: 12300
Description: Expense
LineAmount: 80.00
Quantity: 2.0000
TaxAmount: 0.00
TaxType: NONEUnitAmount: 40.00
AccountCode: 12300
Description: More Epenses
LineAmount: 10.00
Quantity: 1.0000
TaxAmount: 0.00
TaxType: NONEUnitAmount: 10.00

----------------------------------------------------------------------------------------------------------------


there are some inconsistencies in data (including spelling errors and so forth) ... so instead of using 'Raw Data' I have used 'yogi_Raw Data' with needed corrections -- in any event please have a look at the solution to a bit more generalized problem that i have presented herein