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
No comments:
Post a Comment