+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Countif

  1. #1
    Registered User
    Join Date
    01-22-2004
    Location
    Visalia, CA / USA
    MS-Off Ver
    2016
    Posts
    72

    Countif

    I am trying to do a simple Countif that's apparently more complicated than I remember.

    In Col A, I have a number of different dates.
    In Col. B, I have various letters (X, Y and Z) representing certain events that occurred on the date next to it in Col. A.

    Now on another worksheet, I want to list the same dates in Col. A as headings (one column per unique date). Underneath those dates, I want to count the occurences of X, Y and Z (the events) by the date they occurred. In other words, count only the EVENTS in Col. B of Worksheet 1 whose date (Col. A) matches the heading date in Worksheet 2

    I swear I used to be able to do this but I can't get it to work. I know you can only have one criterion with Countif but I think I DO only have one.

    Thanks for any help.
    Bill in CA

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Countif

    Why do you need to transpose the date from a column to a row? This could present a problem if you are using a pre-2007 version of Excel since there are only 256 columns and you could, conceivably, have 365 unique dates.

    You are much better off using a Pivot Table. It will do the analysis very efficiently and with a lot of flexibility. See this link on Pivot Tables
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    01-22-2004
    Location
    Visalia, CA / USA
    MS-Off Ver
    2016
    Posts
    72

    Re: Countif

    Sorry, I didn't explain this very well and am attaching a sample file. This is a mailing to customers done periodically throughout the year. The dates in column A are the dates each mailing is sent and the response to those mailings (if any) is in column B (I = request for more info., Z = not interested, R = request a salesman call).

    We want to determine if the time of year we do a mailing has any influence of the responses (i.e. do we get a higher response rate to mailings done in the fall versus right around Christmas). So the blank boxes in column E through L are supposed to count the occurrences of I, Z, and R by the unique date shown above it. Note that in Col A there are multiple instances of the same date (each date represents a specific customer) but that in E through L there is only one unique date, under which the counts should be shown.

    I hope this makes things a little clearer. Thanks for your response so far.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Countif

    G'day

    Does this help ??

    Copy and paste the formula into cell E3 and copy drag down and across
    Please Login or Register  to view this content.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  5. #5
    Registered User
    Join Date
    01-22-2004
    Location
    Visalia, CA / USA
    MS-Off Ver
    2016
    Posts
    72

    Re: Countif

    That's exactly it! Many thanks.

+ 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