Month Criteria in Countifs ????

Thank you very much for your detailed explanations as usual and now I have same to know that why some of my work sheets always takes some time to open. But unfortunately I’ve used some volatile formulas in those sheet as well
I’ve checked all your above formulas and came to know the speed between the usage of sumproduct and countif ….
I’ve one very large worksheet and upon creation of that file, I couldn’t use any other formulas except Sumproduct and my that sheet is damn slow. Actually I feel comfortable with sumproduct especially when we are using multiple conditions . Anyhow, I’ll reduce the size and will try to share in forums for some quick tip.
Anyway again thanks a lot.