Results 1 to 10 of 10

Vlookup / Countif Combination

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2017
    Location
    Durham
    MS-Off Ver
    2010
    Posts
    38

    Vlookup / Countif Combination

    Hello, I am trying to apply a vlookup / countif combination on a simple dataset.

    I have several consecutive zones of varying lengths. Some actions have been applied on subsections within these zones therefore I want to count how much has been completed.

    For example;

    Zone 1: 50 to 65, Action 1 was completed between 60 and 70, therefore the count is 5.

    Please see attached worksheet with manually completed desired output.

    As always your help is much appreciated.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif Unique combination!!!
    By deadlyliquidxxx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 03:08 PM
  2. Macro code needed for combination of (If,Countif,vlookup)
    By Dharmadme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2014, 03:58 PM
  3. countif-sumif combination??
    By dumaser88 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2013, 02:37 PM
  4. Combination of CountIF, IF, and NOT
    By shani20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2011, 06:58 PM
  5. Combination of Countif and Vlookup?
    By Janusian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2009, 04:48 AM
  6. COUNTIF/VLOOKUP/MATCH combination
    By gmcana in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2008, 04:32 PM
  7. [SOLVED] COUNTIF COMBINATION??
    By Heather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2005, 10:06 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