Analyze some Data for Formula S2

Report of the excel S2

Your report is perfectly ready in the format you want. I have used IF conditions to arrive to the result in cells H and L. I have complete excel sheet ready and if you want I can send it to you by email. My Solution is perfectly working.