+ Reply to Thread
Results 1 to 6 of 6

Using CountIfs

  1. #1
    Forum Contributor
    Join Date
    05-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    378

    Using CountIfs

    Ok...so here is the deal. I have columns that are labeled by month. Then each column has a set of data points that represent a particular item repaired during that month. I can use the regular Countif formula to calculate the total number of data points based on a particular data criteria. However, I would like to be able to break it down by month rather than a lump sum. When I used the CountIfs formula, nothing was calculated. Any ideas?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Using CountIfs

    Can you post a sample book?

    What was the COUNTIF formula that worked...
    What was the COUNTIFS formula that didn't?

  3. #3
    Forum Contributor
    Join Date
    05-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: Using CountIfs

    I have provided a sample book. Look in column "M", that column the countif worked correctly. Column "O" was the column in which I was trying to do Countifs formula.
    Attached Files Attached Files

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Using CountIfs

    I'm not sure what all that other stuff you had in there was, but see if this helps.

    Put the month text in M2 (Jan Feb Mar, etc)
    Put your criteria in N2 down as far as needed (DE, LI, MP etc)
    Then in O2 and filled down is
    =COUNTIF(INDEX($A:$L,0,MATCH($M$2,$A$1:$L$1,0)),N2&"*")
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-13-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    378

    Re: Using CountIfs

    I think this works great...Thanks!

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Using CountIfs

    Great, glad to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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