Results 1 to 9 of 9

Counting cells in B based on text in column A

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Philadelphia
    MS-Off Ver
    Excel 20010
    Posts
    16

    Counting cells in B based on text in column A

    Hello,

    I have a 2 column Excel sheet: Column A contains a random assortment of months (January - December). Column B contains various names (see attachment).

    I would like a cell in a separate workbook to give me the total cells in column B that have January in column A. However, there may be duplicates, which I do not want (There could be multiple rows that have January in column A & Sarah in column B, but they should only count as 1).

    So far I've been able to use COUNTIF to count how many cells are in a column, minus the duplicates: =SUM(1/COUNTIF(Range1,Range1))
    I've also been able to use COUNTIFS to get a sum of how many cells contain a specific string of text:=COUNTIFS(Range2,"criteria2")

    I think I need to combine these 2 in some way, but I can't quite figure out how to do it.

    Can anyone help me out here? I'd really appreciate it!

    Thanks =]

    Jackie
    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. counting blank cells in range based on condition using another column
    By TheBlueBell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2013, 04:58 PM
  2. Counting Text based on specific criteria in another column
    By djreddy in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 08-26-2013, 09:35 AM
  3. Counting Unique text in column B based on a criteria from column a
    By clocmasta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 06:40 PM
  4. Counting cells in offset column based on contents of another column.
    By Big Chris in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2008, 09:25 AM
  5. COUNTING TEXT CELLS IN A COLUMN
    By Maureen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2005, 02: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