Let's say, I have a sheet with these 2 columns, where column A is for 'Remarks' and B is for 'Date'. 2nd and 4th rows are intentionally left blank to simulate that no Remarks and Date are provided.
A B
-------- -----------
Auto Closed 11/25/2018
DEC-2018 12/3/2018
Auto Closed 12/5/2018
Auto Closed 12/12/2018
Now, I need to find out the number of records that are "Auto Closed" in December (12).