Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif conditional
I have two columns of dates, a year and a month, non sequential, like this:
1994 Jan 1990 Jan 1993 May 1994 Apr 1994 Jan 1991 Nov Etc. I want to be able to count the number of times each month/dat combinations appears. For example, How many 1994 Jan combinations do I have (2) how many 1993 May (1) etc. Is there a way I can do this using countif? |
#2
|
|||
|
|||
Ken,
Use a pivot table: Select your data, use Data | Pivot table... then click through to where you have a blank table. Then drag the year to the row field, the month to the row field, and the month again to the data field, and you're done. HTH, Bernie MS Excel MVP "Ken" wrote in message ... I have two columns of dates, a year and a month, non sequential, like this: 1994 Jan 1990 Jan 1993 May 1994 Apr 1994 Jan 1991 Nov Etc. I want to be able to count the number of times each month/dat combinations appears. For example, How many 1994 Jan combinations do I have (2) how many 1993 May (1) etc. Is there a way I can do this using countif? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on Conditional COUNTIF | Excel Worksheet Functions | |||
Countif and Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions |