+ Reply to Thread
Results 1 to 4 of 4

Vlookup / Countif Combination

  1. 06-08-2023, 03:26 PM #1
    Metcalfe77
    Metcalfe77 is offline
    Registered User
    Join Date
    06-08-2023
    Location
    Durham
    MS-Off Ver
    365
    Posts
    2

    Vlookup / Countif Combination

    Hello, I am struggling to create a formula with a vlookup / countif combination.

    In the attached example worksheet, I would like to count 'Low' values in column C and populate cells E3 to G3 dependent on where they fall within the range in Columns A and B.

    I think it is the '>' and '<' values in the statement that I am struggling with.

    Current formula I am using to no avail is =COUNTIFS(A3:A22,>=0.5,B3:B22<=0.8,C3:C22,'Low')

    Many thanks for any help, this is my first post under my new email address I have used the forum with gratitude previously!

    Metcalfe77
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-08-2023, 03:46 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Vlookup / Countif Combination

    not sure where the vlookup comes in but to populate E3 to G3 use...
    E3 =COUNTIFS($A$3:$A$22,">="&0.5,$B$3:$B$22,"<="&0.8)
    F3 =COUNTIFS($A$3:$A$22,">="&1,$B$3:$B$22,"<="&1.5)
    G3 =COUNTIFS($A$3:$A$22,">="&1.7,$B$3:$B$22,"<="&2)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 06-08-2023, 03:52 PM #3
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,212

    Re: Vlookup / Countif Combination

    Try

    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  4. 06-08-2023, 06:09 PM #4
    Metcalfe77
    Metcalfe77 is offline
    Registered User
    Join Date
    06-08-2023
    Location
    Durham
    MS-Off Ver
    365
    Posts
    2

    Re: Vlookup / Countif Combination

    Works perfect, thankyou!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup / Countif Combination
    By Metcalfe in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-10-2018, 10:10 AM
  2. [SOLVED] Sum and Countif Combination Formula
    By JPSIMMON in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-03-2015, 02:36 AM
  3. 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
  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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1