Help Needed on Conditional Formatting

Hello,

I have a little problem.
In the attached excel 1st tab is the raw data, 2nd tab is where i am trying to pull the data.

In the 2nd tab, i want to calcuate the number of counts(#) for GCP, Non Complex and Complex ie.H3, I3, J3
Also want to calculate the average (CST). Average is calculated on basis of Total counts divided number of counts. E3, F3, G3

Thanks in advance,
Arnab