Count/Find X on multiple lines w/ multiple criteria
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!
Last edited by artistapart; 10-28-2016 at 12:28 PM.
Re: Count/Find X on multiple lines w/ multiple criteria
Your file appears to be corrupted. Please upload again...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By nik1703 in forum Excel Formulas & Functions
Last Post: 05-26-2015, 07:29 PM
By Jonathan68 in forum Excel Formulas & Functions
Last Post: 02-13-2014, 06:04 PM
By lsudecat04 in forum Excel Formulas & Functions
Last Post: 06-28-2013, 05:41 AM
By cvercrus in forum Excel Formulas & Functions
Last Post: 02-04-2013, 12:32 PM
By jimdao111 in forum Excel General
Last Post: 04-05-2011, 07:09 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1