# CountIf by year in a current year

**URL:** <https://boards.straightdope.com/t/countif-by-year-in-a-current-year/683011>\
**Category:** Factual Questions\
**Created:** [March 6, 2014, 2:19pm UTC](https://boards.straightdope.com/t/countif-by-year-in-a-current-year/683011 "2014-03-06T14:19:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![donedeal](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@donedeal](https://boards.straightdope.com/u/donedeal)\
**Post date:** [March 6, 2014, 2:19pm UTC](https://boards.straightdope.com/t/countif-by-year-in-a-current-year/683011/1 "2014-03-06T14:19:11Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![KneadToKnow](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kneadtoknow/32/3999_2.png) [@KneadToKnow](https://boards.straightdope.com/u/KneadToKnow)\
**Post date:** [March 6, 2014, 2:28pm UTC](https://boards.straightdope.com/t/countif-by-year-in-a-current-year/683011/2 "2014-03-06T14:28:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![KneadToKnow](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kneadtoknow/32/3999_2.png) [@KneadToKnow](https://boards.straightdope.com/u/KneadToKnow)\
**Post date:** [March 6, 2014, 2:34pm UTC](https://boards.straightdope.com/t/countif-by-year-in-a-current-year/683011/3 "2014-03-06T14:34:37Z")

</div>

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.
