My formula will work on a single sheet (is actually simplier)
I modified your sheet a little. I assume there will be more than 1 sample set so added a sample 1 and sample 2 and then in the new table, I used Sample 1 and Sample 2 in Col E.
To get AVERAGE in F10 for example,
To Get Standard deviation in F11
You would need to copy and paste those formulas down every other row, a pain in the neck if you have lots of samples. I combined the formulas with an IF statement that looks to see if the row is odd or even and then does the appropriate formula
Alternately, you could set it up a little different as I did in the table in E17. Lots of options depending on how much data you have and how important it is to have the average and Std dev together.
Bookmarks