+ Reply to Thread
Results 1 to 2 of 2

I need a count of cells in a column based on criteria on that line in a different column

  1. #1
    Registered User
    Join Date
    03-10-2014
    Location
    Grapevine, TX
    MS-Off Ver
    Excel 20010
    Posts
    0

    I need a count of cells in a column based on criteria on that line in a different column

    I have two columns. Column A had numbers and column B has names. I need a count from column A for each name in column B.

  2. #2
    Registered User
    Join Date
    03-10-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: I need a count of cells in a column based on criteria on that line in a different colu

    Create a new column with the equation =if(a1=$d$1,b1,0)
    In the cell d1 put the name you want and in the cell e1 put equation =sum(c:c)

+ 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. Count cells in row based on criteria in column & Row as well
    By divi123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2014, 04:45 AM
  2. Replies: 8
    Last Post: 03-03-2014, 06:53 AM
  3. [SOLVED] Trying to count cells greater than # in one column if another column meets criteria
    By lorne17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-14-2012, 07:01 PM
  4. Replies: 5
    Last Post: 09-18-2011, 10:44 PM
  5. Count Values in Column B based on Criteria in Column A
    By brughel in forum Excel General
    Replies: 5
    Last Post: 04-17-2009, 02:30 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