formula to give sample number of a certain sample type and on a certain day

Good afternoon,   I need some help with a formula I want to use. I am trying to put together a formula that gives me a number if some conditions are met. The example excel is as follows: Produ...