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

    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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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

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

    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
    Office 365 v 2403
    Posts
    13,396

    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
    Office 365 v 2403
    Posts
    13,396

    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)

Similar Threads

  1. Flag value in col d based on value in col b
    By SGW in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-19-2014, 01:40 PM
  2. Replies: 5
    Last Post: 12-20-2013, 04:57 PM
  3. Replies: 2
    Last Post: 03-12-2013, 04:10 PM
  4. [SOLVED] Search and Flag the Emails in Outlook based on the Data in Excel (Subject column)
    By anchuri_chaitanya in forum Outlook Programming / VBA / Macros
    Replies: 9
    Last Post: 03-17-2012, 12:35 AM
  5. Hard? SUM the values of a column that matches a flag in an adjacent column
    By Nokao in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-07-2012, 11:29 AM
  6. Replies: 2
    Last Post: 02-18-2005, 10:06 AM
  7. Replies: 2
    Last Post: 02-18-2005, 10:06 AM

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