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.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody></tbody>
Appreciated you valuable response. Thanks
Best Regards,
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,