So, I've come to a wall. The wall of pain. I have two columns of critical numerical data (Columns B and C), the rest of the columns are informative and categorical (Columns A, G and H). I'm trying to gain the standard deviation of multiple criteria similar to that of SUMPRODUCT() but "STDEVPRODUCT()".
Formula for finding average of sumproduct:
A3 is where a user can type in informative data to match the data found in columns G as part of the sumproduct function.
So, is there a formula that can provide the standard deviation of the above formula? If so, what is the formula?
Bookmarks