faiselsaffarini
New Member
- Joined
- Feb 1, 2022
- Messages
- 3
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
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.
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.