COUNTIFS based on HIJRI&Gregorian Years and months

Hi everyone, this is my first post.

I want to summarize/Count the set of data based on Hijri and Gregorian Years and Months, but the problem is the date columns contain BLANKS, TEXT and few cell values are based on formula.

I'm attaching excel2010 worksheet as an example.

Your help will highly be appreciated.

Thanks
Qadeer