+ Reply to Thread
Results 1 to 2 of 2

Count/Find X on multiple lines w/ multiple criteria

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    13 54636556
    MS-Off Ver
    Excel 2011
    Posts
    30

    Count/Find X on multiple lines w/ multiple criteria

    Sample attached

    Column G has the manual results i'm looking for- this is where I want a formula to figure out the math. The parameters are based on column B- Rows will be 2 and up.

    It should only count if Column D has a *New* **WITH** an upgrade. If its a single invoice number with one or more new, its ignored. if its a single invoice with 1 or more upgrades its ignored. It is counted when its a new with an upgrade.

    If it has 10 new and one upgrade, its still 1- basically its "yes, this invoice number has those two things together, not how many of them are together".

    Hope that makes sense- thanks for any help!
    Attached Files Attached Files
    Last edited by artistapart; 10-28-2016 at 12:28 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,036

    Re: Count/Find X on multiple lines w/ multiple criteria

    Your file appears to be corrupted. Please upload again...
    Glenn



+ 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. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  2. [SOLVED] Find matching lines based on multiple criteria
    By Jonathan68 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2014, 06:04 PM
  3. Schedule to count multiple lines and columns to meet two criteria
    By lsudecat04 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-28-2013, 05:41 AM
  4. Replies: 5
    Last Post: 02-04-2013, 12:32 PM
  5. Replies: 3
    Last Post: 04-05-2011, 07:09 PM

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