+ Reply to Thread
Results 1 to 5 of 5

Adding numerators and denominators seperately

  1. #1
    Registered User
    Join Date
    09-19-2018
    Location
    sheffield
    MS-Off Ver
    7
    Posts
    3

    Thumbs up Adding numerators and denominators seperately

    Hi

    I'm hoping someone can help. I have data in cells D6,G6 and J6 that are fractions. I want to add these to get a total but I'm struggling.

    I need it to add numerators and denominators seperately so that values of 0/2, 0/2, 2/2 gave a result of 2/6. I also need it to ignore cells that contain a non-fraction (some cells contain the phrase NT).

    Thanks in advance

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    16,248

    Re: Adding numerators and denominators seperately

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    27,477

    Re: Adding numerators and denominators seperately

    Maybe this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    09-19-2018
    Location
    sheffield
    MS-Off Ver
    7
    Posts
    3

    Re: Adding numerators and denominators seperately

    Thanks

    I have attached an example as requested. So in the historical/cumulative columns i need to have the data added up for each test for each person individually.

    Hope that makes sense
    TIA
    Attached Files Attached Files

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    27,477

    Re: Adding numerators and denominators seperately

    This works where all the tests are complete but not in the case of "NT" values.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Maybe it will help to get started. Maybe you could put 0/0 rather than NT? You could use Conditional Formatting to highlight the "0/0" values.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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