+ Reply to Thread
Results 1 to 5 of 5

summation based on flag index in another column

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    74

    summation based on flag index in another column

    Sl. No., Description, Qty, Unit, Rate, Amount, Flag are the fields of an excel sheet.

    If the flag field is “tot”, then the corresponding cells above the Amount field from flag “h” to flag “tot” should be summed, else (i.e. if the flag is “s” or “m”) the amount field should be the product of rate and qty.

    There will be different “h” fields in the flag based on the different headings. Hence, the items immediately up to the first “h” while searching up from “tot” flag should only be included in the total.

    What is the formula to be used in Amount column for this to be entered in Amount column?

    image of sample file is attached here http://s000.tinyupload.com/?file_id=...21600677011075

    Excel file is attached here http://s000.tinyupload.com/?file_id=...65366415914068

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: summation based on flag index in another column

    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    04-05-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    74

    Re: summation based on flag index in another column

    attachment is provided as instructed
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,459

    Re: summation based on flag index in another column

    Try this formula in F2 and filled down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    11,459

    Re: summation based on flag index in another column

    melvinkoshy, thank you for the feedback/rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It helps.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1