LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ken
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on Conditional COUNTIF Question on Conditonal Countif Excel Worksheet Functions 2 February 13th 05 07:29 PM
Countif and Conditional Formatting Ramiro Espinoza Excel Worksheet Functions 1 February 2nd 05 05:21 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
countif reno Excel Worksheet Functions 5 November 5th 04 12:20 PM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"