i wannted to know like there in hint given to us and for first question the hint is like to use countif function...so we have to use countif function only or we can do it by some other way for eg by using pivot table.
