Running GSD on a series of cells that holds up to 20 values maximum, of which I want to calculate the GSD and exclude the cells in the range that are empty. Straight forward GSD formula fails if no blank value is detected.
In cells A3: T3 is a table of sample values. Not all are filled. Example, A3:C3 are: .1, 3, and 4 respectively. Running a GSD formula =EXP(STDEV(LN(A3:C3))) yields a correct GSD value of 3.82. However for the life of me I cannot remember how to run the GSD on the entire range whereby it ignores the blanks and only produces a GSD based on nonblank values.
How do I exclude the blank cells in my formula?
In cells A3: T3 is a table of sample values. Not all are filled. Example, A3:C3 are: .1, 3, and 4 respectively. Running a GSD formula =EXP(STDEV(LN(A3:C3))) yields a correct GSD value of 3.82. However for the life of me I cannot remember how to run the GSD on the entire range whereby it ignores the blanks and only produces a GSD based on nonblank values.
How do I exclude the blank cells in my formula?