+ Reply to Thread
Results 1 to 2 of 2

frequency count that meets another columns criteria

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    Boston, Ma
    MS-Off Ver
    Excel 2010
    Posts
    1

    frequency count that meets another columns criteria

    Ok, first time poster here! hello. So below is what I've been searching to do. 1 workbook, 2 sheets. Titled cause code and raw data.

    column A in the cause code sheet has multiple labels channel marketing, training, email etc. I need to have the formula be input into the column next to it. column N in the raw data sheet also list these same labels and column quarter, column month. I need a way to count how many times in the raw data sheet a label appears that equals a certain quarter and certain month.

    How many times do all the labels appear in column N, if column O equals Q3, and column P equals Sep. Then input that number in sheet cause code, next to the matching label.

    Any help is GREATLY appreciated!!!

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: frequency count that meets another columns criteria

    Hello Pardimix can you please upload sample data ?
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ 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. Need one column total if criteria meets another columns criteria
    By jebrown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 08:47 PM
  2. count the number of occurrences when value meets 3 x criteria
    By tiggi in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-26-2013, 03:12 PM
  3. Trying to count every second cell in a column that meets certain criteria
    By RalphCr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2012, 08:40 AM
  4. Replies: 1
    Last Post: 02-16-2012, 09:57 AM
  5. how can i count a number that meets a criteria?
    By oakm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2005, 03:07 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