+ Reply to Thread
Results 1 to 6 of 6

Using COUNTIF with VLOOKUP to return # of results for a given date

  1. #1
    Registered User
    Join Date
    09-25-2023
    Location
    Chicago, IL, USA
    MS-Off Ver
    Currently Using MS Excel web application
    Posts
    3

    Using COUNTIF with VLOOKUP to return # of results for a given date

    Hi folks!

    I'm working on creating a client tracking sheet which tracks some metrics for drop-in clients who are coming in at a given date. So far my SUMIF function seems to be working, pulling number of services given on a specific date, but since each of these are separate columns which effectively just have to be ticked per visit, it seems that a similar format isn't working for a different issue: I'm trying to count number of clients who have the same trait (in this case, race), and return a value of # of clients who belong to that demographic. Below is my current Formula I'm using:

    =COUNTIFS('Input Data'!J:J,VLOOKUP(A2,InputData,10,FALSE),="Latinx")

    So the idea is that in the "Race" column there are different values: Black or AA, White, Latinx, Asian etc. On the output calculator I am trying to get it to read that column and return all people who have "Latinx" marked as their race, then I would have other columns for the other races that would use a similar format. I feel like it should be straightforward, but for some reason I can't get my head around it. Any advice?

    In the attached file, the formula should return 2 Latinx clients.

    Thanks!
    Parker
    Attached Files Attached Files
    Last edited by BelleSprout; 09-25-2023 at 04:19 PM. Reason: Question Answered, thank you!

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,591

    Re: Using COUNTIF with VLOOKUP to return # of results for a given date

    Hi and welcome

    Perhaps I'm missing what it is you're trying to achieve as I'm not sure why you're using VLOOKUP here at all.

    Give the below a try and see if it does what you need.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Registered User
    Join Date
    09-25-2023
    Location
    Chicago, IL, USA
    MS-Off Ver
    Currently Using MS Excel web application
    Posts
    3

    Re: Using COUNTIF with VLOOKUP to return # of results for a given date

    Hi there!

    I think you might be right, I think I overcomplicated it all! I have an appointment but will give it a shot when I get back to see if it returns what I need. Thank you! I've been filling a position for my former supervisor and was previously just doing entry more than actually forming the sheets.

    Thanks!

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,591

    Re: Using COUNTIF with VLOOKUP to return # of results for a given date

    No problem. I'll check back later to see how you got on with it.

    BSB

  5. #5
    Registered User
    Join Date
    09-25-2023
    Location
    Chicago, IL, USA
    MS-Off Ver
    Currently Using MS Excel web application
    Posts
    3

    Re: Using COUNTIF with VLOOKUP to return # of results for a given date

    Thanks, BSB!

    Worked like a charm. Good reminder to "Keep It Simple, Silly" haha

    -Parker

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,591

    Re: Using COUNTIF with VLOOKUP to return # of results for a given date

    It's easy to over complicate things in Excel. Sometime just need a fresh pair of eyes to see through the confusion.

    And yes, I fully agree with you on the KISS principle.

    BSB

+ 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. [SOLVED] VLOOKUP to return multiple results from data relating to a specific date
    By Sedgeway in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2020, 09:01 AM
  2. Help using vlookup to return multiple results for one vlookup value
    By Akmon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2015, 06:00 AM
  3. [SOLVED] COUNTIF doesn't return any results
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2012, 10:05 AM
  4. Vlookup (or something!) to return multiple results?
    By Madraykin in forum Excel General
    Replies: 3
    Last Post: 04-24-2012, 11:30 AM
  5. Vlookup to return multiple results?
    By cdotyii in forum Excel General
    Replies: 8
    Last Post: 09-05-2011, 10:23 AM
  6. Vlookup and return value from a range of results?
    By homer123456 in forum Excel General
    Replies: 10
    Last Post: 01-11-2011, 07:41 PM
  7. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM

Tags for this Thread

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