Count IF Average, Median , SD and Range

Hello fellow Excel Wizards

I have a large data set which is probably going to grow to about 50,000 lines

I'm trying to get a summary of the data together of 2 decimal placed numbers based around a CountIf Formula to work out the above topic mentioned details.

I've attached an example of the data tab and summary sheet that I'm trying to work out.

I started using the SUMIFS/COUNTIFS for the averages and messing around with the other functions with CountIfs and arrays but can't get the right combination.

Help is always appreciated

Regards
Matt