CountIf by year in a current year

Factual Questions
1

Dear Guru,

I am a newbie memeber of this forum, and currently assign into a new assignment which dealing an excel file everyday. We have one excel file for moniroting of action items generated by the management after the study. As since there were around 2,500+ rows has been generated since in the beginning of 1990’s till todate. So I was thinking of instead of getting the result through filter manually, I want to create a formula that will count of how many has been closed this year out of the total numbers of action items.

Is it possible to use the COUNTIF formula to count the number of items in Col C, where Col B contains a date?

2-Jan-13 Closed
2-Jan-13 Closed
5-Jan-13 Closed
19-Feb-13 Closed
16-Feb-13 Closed
22-Feb-13 Closed
2-Mar-14 Closed
5-Mar-14 Closed
8-Mar-14 Closed
10-Mar-14 Closed
15-Mar-14 Closed

Appreciated your valuable response.

Best Regards,

2

I believe countif will only evaluate the criteria against the same range you want the count to happen, but countifs will allow you to evaluate criteria against one range while counting another. Double checking now.

ETA: I was close. It evaluates and counts across multiple ranges, so I was close. Use Excel’s online help to look at the example, it explains it better than I can. But basically, you should be able to evaluate your date to be “= year(2013).” Granted, I think this is just an elegance upgrade over using the and function.

3

ETA paragraph above should read:

I was close. It evaluates and counts across multiple ranges, so I was close. Use Excel’s online help to look at the example, it explains it better than I can. But basically, you should be able to evaluate your date to be “= year(2013)” and your second criteria “=“Closed”” or whatever you’re looking for. Granted, I think this is just an elegance upgrade over using the and function.

Edit window closed before I could fix.