Results 1 to 2 of 2

Thread: Am not comfortable with Pivot table. Would like to use a formula

  1. #1

    Unhappy Am not comfortable with Pivot table. Would like to use a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am trying to sum up the invoice amount based on the following:


    1. Cost Center Name:
    2. Cost center
    3. GL Account.


    Each cost center name has a cost center linked to it and each cost center has a number of GL Code linked to it. What I am trying to sum is the invoice amount for all GL Codes separately under a cost center & Cost center name.
    My raw data is in Cells b10:j288 as of now.
    The result which I expect is as given in rows 3,5,7 & 9.

    Am using excel 2013.

    Thanks,
    Ciaz
    Attached Files Attached Files

  2. #2
    Excel 2010
    Excel 2013 compatible.
    Some amounts formatted by you as text or with extra characters resulted in million dollar errors.
    http://www.mediafire.com/view/1z0ut1hwsqc2r9l/08_10_15.xlsx


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •