How should I proceed? When I do =STDEV(IF(B2:B599 "Yes") H2:H599) and finish with CTRL, SHIFT + ENTER, it gives the error "#VALUE!". Standard Error, 0.444401, This is the sample estimate of the standard deviation. I get different types of errors such as "#DIV/0!" or "#".įor example, to start of easily, I only want one condition to be met ("Yes" in B2:B599). Adjusted R Square, 0.605016, Adjusted R2 used if more than one x variable. I think I should start the formula with =STDEV(IF(. So, it only calculates the mean of the colum H if in the colums B and D a 'Yes' is given, and in colums E and F the value is higher then 22,29 and 69,9, respectively. In two colums, the conditions are simply 'Yes' or 'No', and in two other colums, they are numbers. I want Excel to calculate a standard deviation, but only if some conditions are met. I have a question about the use of the functions ST DEV and IF or IFS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |