Autofilling DSTDEV function with multiple criteria and 1 heading

[faiselsaffarini]

I am an excel novice. Unless there's an easier way (nesting IF and STDEV function, could not figure this out), I am trying to use DSTDEV to calculate stdev of measurements (in a database in different sheet) if the criteria from another column matches.

Picture below shows the primary page of which I am trying to perform calculations.

I want to calculate standard deviation of all measurements in this sheet (~1000000 data points across ~200 "test types") with Col B "TT" matching "TT" in the main sheet.

If I'm understanding it correctly, this formula would need the heading in order to perform correctly, which means I can't autofill this function if so. Is there any better way to do this?

Any help is greatly appreciated.

 

[faiselsaffarini]

Please ignore the values in H3 and H4, those are manually filled. I hopefully there is an easier way to autofill so I don't have to manually select 200 types of data. lol

 

[faiselsaffarini]

Solved with a Pivot Table. Woo