Count If function

[chatnet26]

Dear Guru,

We have one excel file for monitoring of action items generated by the management after the study. As since there were around 3000+ rows has been generated since in the beginning of 1990's till to-date. 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 and this month out of the total numbers of action items.

Is it possible to use the COUNTIF function formula to count the number of items in column A, and date of column B, and closed in column C.

In below, we can see that there were 4 items under Revalidation has been closed this month and the total number of closed this year is 6.

TYPE	MTD Closing Date	Status
Project	2-Jan-13	Closed
Project	2-Jan-13	Closed
Project	5-Jan-13	Closed
Project	19-Feb-13	Closed
Project	16-Feb-13	Closed
Revalidation	22-Feb-14	Closed
Revalidation	2-Feb-14	Closed
Revalidation	5-Mar-14	Closed
Revalidation	8-Mar-14	Closed
Revalidation	10-Mar-14	Closed
Revalidation	15-Mar-14	Closed

<colgroup><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody></tbody>

Appreciated you valuable response. Thanks

Best Regards,

 

[chatnet26]

Dear Guys,

Thank you for all your help. It was really helpful to have your input. I really appreciated your time you spent with me.

Thank God, you were there. Thank you!

God Bless us all.

Best Regards,

 

[Aladin Akyurek]

Glad to be helpful. Thanks for providing feedback.

 

[gazz]

Hi gazz,

I found a bit problem in the formula of counting the current month because it will read/count which has been closed even in the previous years that falls to the month of March. It gives me a total of 581.

I need your help please to figure it out. Thanks

Best Regards,

Hi chatnet26, sorry I didn't log on during the weekend and also sorry my answer didn't quite work for multiple years but I think you have the full solution from another member now. good luck

Regards

 

[chatnet26]

Dear Aladin,

Apologize of you my tardy reply as we are having a turn around. Again thank you so much with your kind support and really it was a perfect method that meets my requirements.

Again guys, thank you so much with your valuable time and approach.

God Bless.

Best Regards,

 

[Aladin Akyurek]

Dear Aladin,

Apologize of you my tardy reply as we are having a turn around. Again thank you so much with your kind support and really it was a perfect method that meets my requirements.

Again guys, thank you so much with your valuable time and approach.

God Bless.

Best Regards,

You are welcome. Thanks for providing feedback.