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?
Appreciated your valuable response.