+ Reply to Thread
Results 1 to 4 of 4

Summing or displaying based on whats entered

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    61

    Summing or displaying based on whats entered

    I need to devise a way of displaying or adding numbers based on where a flag is entered.

    If there is only one flag in the area it should display the set numbers, however if there are 2 or more flags NEXT to each other it needs to sum where necessary the numbers

    Please see attached, any help is extremely appreciated!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: Summing or displaying based on whats entered

    You have had almost 60 views of your thread and no suggestions This tells me that members may not understand what you want (I know I dont). It may help if you try to explain/show your requirements in a different way?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Summing or displaying based on whats entered

    Hi Ford,

    It is hard to explain, i thought the attachment might explain it better, i have included examples in there too..

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,799

    Re: Summing or displaying based on whats entered

    Yes I looked at those too, didnt really help me much

    Maybe is you explained step-by-step what you are trying to do?

+ 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. Grouping, Summing, and Displaying data based off of user inputs
    By AlphaSkidz in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 10-05-2013, 08:11 AM
  2. [SOLVED] Displaying text in a cell depending on the value entered
    By Rhiannon25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 07:21 PM
  3. Summing based on entered date
    By ewest305 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2012, 09:24 PM
  4. Displaying Data Entered That Day
    By AWat in forum Excel General
    Replies: 1
    Last Post: 10-29-2009, 06:07 PM
  5. Replies: 0
    Last Post: 05-25-2009, 06:58 PM

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