Excel 2007 : Countif

[wmjenner]

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.

[Palmetto]

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

[wmjenner]

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.

[ratcat]

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.

[wmjenner]

That's exactly it! Many thanks.