Results 1 to 17 of 17

How to Count a Column if it matches certain data

Threaded View

hartjohnson How to Count a Column if it... 10-29-2015, 03:24 PM
berlan Re: I think this is a MATCH... 10-29-2015, 03:30 PM
hartjohnson Re: I think this is a MATCH... 10-29-2015, 03:34 PM
berlan Re: I think this is a MATCH... 10-29-2015, 03:44 PM
hartjohnson Re: I think this is a MATCH... 10-31-2015, 04:15 PM
FDibbins Re: I think this is a MATCH... 10-31-2015, 05:07 PM
hartjohnson Re: I think this is a MATCH... 10-31-2015, 06:04 PM
hartjohnson Re: How to Count a Column if... 10-31-2015, 06:18 PM
FDibbins Re: How to Count a Column if... 10-31-2015, 06:46 PM
hartjohnson Re: How to Count a Column if... 10-31-2015, 06:57 PM
FDibbins Re: How to Count a Column if... 11-01-2015, 12:18 AM
hartjohnson Re: How to Count a Column if... 11-01-2015, 12:54 AM
FDibbins Re: How to Count a Column if... 11-01-2015, 01:25 AM
hartjohnson Re: How to Count a Column if... 11-01-2015, 10:55 AM
oeldere Re: How to Count a Column if... 11-01-2015, 05:05 AM
hartjohnson Re: How to Count a Column if... 11-01-2015, 10:57 AM
hartjohnson Re: How to Count a Column if... 11-01-2015, 04:19 PM
  1. #10
    Registered User
    Join Date
    10-29-2015
    Location
    California
    MS-Off Ver
    Mac 2011
    Posts
    25

    Re: How to Count a Column if it matches certain data

    Right, I got that part, it is the next column over that is not working properly. The formula you gave me does count the number of entries, but it counts the total number of entries based on name. What I need it to do is count each Category individually. For example. Jordan Hill could have 3 separate reviews. However, one of those reviewers does not have to fill in each category. So even though she has 3 total reviews, she could potentially have only 2 scores in a given category. I updated the workbook and highlighted the column that I am having trouble with in Yellow.
    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. Issue: Only returning 1st match on Index/Match
    By tbr2891 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2014, 11:54 AM
  2. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  3. Issue using Index/Match to pull multiple occurrences of "Match" criteria
    By aridfriedman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 11:38 AM
  4. [SOLVED] Index/Match Issue
    By rolo_celticfc in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-14-2013, 09:26 AM
  5. [SOLVED] index match match - issue
    By jw01 in forum Excel General
    Replies: 2
    Last Post: 11-27-2012, 03:53 PM
  6. Index and match issue
    By esupply in forum Excel General
    Replies: 4
    Last Post: 03-11-2010, 12:12 PM
  7. Match index issue?
    By Mparekh in forum Excel General
    Replies: 12
    Last Post: 03-17-2009, 09:56 AM

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