Count distinct values based on two criteria

Hi Alan,

Thanks for your time. But am not sure what value will be. I have more than 400 rows with different values. it will be helpful if i get an alternate solution. Thanks again!