+ Reply to Thread
Results 1 to 3 of 3

Formula needed for dividing 2 sets of cells and excluding adjacent text cells

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    176

    Formula needed for dividing 2 sets of cells and excluding adjacent text cells

    A1:A10 = numbers
    B1:10 = numbers
    C1:C10 = text range
    D1 = Formula

    I want to add all the numbers in the A range and divide the total by the total sum of all the B range however I want to exclude from the totals in both A & B cells any adjacent with specific text in C1:C10.
    EXAMPLE: letter X so all xs in C1:C10 will not calculate the totals in A & B to solve for D.

  2. #2
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Formula needed for dividing 2 sets of cells and excluding adjacent text cells

    Try

    =SUMIF(C1:C10,"<>x",A1:A10)/SUMIF(C1:C10,"<>x",B1:B10)
    Marcelo Branco

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

    Re: Formula needed for dividing 2 sets of cells and excluding adjacent text cells

    Is this a continuation of this thread?

    http://www.excelforum.com/excel-form...red-cells.html.

    If so, it may be easier to continue on that 1 (we can remove the "solved")
    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

+ 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