+ Reply to Thread
Results 1 to 8 of 8

count how many times does each month appear, when another column says X

  1. #1
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    count how many times does each month appear, when another column says X

    See attached.

    Raw data is B and C. I need to generate the numbers in G & H automatically, eg if B says 'person 1', how many times is each month mentioned? Then the boxes get filled in.

    Would be much obliged.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-27-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: count how many times does each month appear, when another column says X

    Person 1 =countifs($b$2:$b$10,$g$1,$c$2:$c$10,f2)
    person 2 =countifs($b$2:$b$10,$h$1,$c$2:$c$10,f2)

  3. #3
    Registered User
    Join Date
    03-27-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: count how many times does each month appear, when another column says X

    Is that what you are looking for?

  4. #4
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: count how many times does each month appear, when another column says X

    Yup. Your reputation points are up, and thread marked SOLVED.

  5. #5
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: count how many times does each month appear, when another column says X

    Hi, now I'd like to do the same, but for entire months - ie 1st to 30th January 2000. The first day of the month is in the same column. The last day is in the next column. I've tried to use

    Please Login or Register  to view this content.
    Which is supposed to cover the whole month. Why isn't it working and what's the best solution?
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: count how many times does each month appear, when another column says X

    =COUNTIFS($B$2:$B$10,$H$1,$C$2:$C$10,"<="&G3,$C$2:$C$10,">="&F2) in H2 works, but it's sort of lousy that MEDIAN doesn't.

  7. #7
    Registered User
    Join Date
    03-27-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: count how many times does each month appear, when another column says X

    Send the example sheet of what you are looking for.

  8. #8
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: count how many times does each month appear, when another column says X

    Thanks, but it's already solved (see [SOLVED] before the forum title).

+ 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] Count number of times the month has appeared
    By Rianne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2013, 10:35 PM
  2. Replies: 4
    Last Post: 02-24-2012, 08:12 AM
  3. How do I count the # of times an entry has been made in a month?
    By Wayne in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 12-28-2005, 05:45 PM
  4. [SOLVED] Re: How to count the number of times something occurs within a certain month
    By Joyce in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2005, 04:05 PM
  5. [SOLVED] How to count the number of times something occurs within a certain month
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 02:05 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