St Dev If doesn't seem to calculating correctly

[Simon1662016]

I'm using a Standard Deviation + If formula:
=STDEV.P(IF('Numerical Results'!$A$2:$A$415='St Dev'!A2,'Numerical Results'!$B$2:$B$415)) and have entered using CTRL+SHIFT+ENTER

This appeared to be working correctly. I decided to spot check a couple of the results to be sure, so I filtering the relevant values in Column A on the "Numerical Results" tab, and did a simple "STDEV.P" formula on the corresponding results in Column B. However, the results I got from the STDEV.P check were different to the results pulled from the STDEV.P(IF( formula.

Results from STDEV.P(IF:
0.50
0.48
0.29
0.64
0.77

Same results from manually filtering the data, and using STDEV.P:
0.00
0.00
0.00
0.29
0.00

Can anyone suggest some reasons what I could be doing wrong, or why the results are different?

Thanks

 

[Aladin Akyurek]

Without the data it's hard to do a diagnosis.

Does the following help? Control+shift+enter:

=STDEV.P(IF('Numerical Results'!$A$2:$A$415='St Dev'!A2,IF(ISNUMBER('Numerical Results'!$B$2:$B$415),'Numerical Results'!$B$2:$B$415<strike></strike>)))

 

[Kenneth Hobson]

Not sure what you mean by manually filtering. When using filter, you need to use =SubTotat()

 

[Simon1662016]

Thanks everyone for your responses.

I have played around a bit more, and think I've figured this out - there were some blank cells in the Numerical Results Column B which appear to have caused this issue. When I removed the rows with blanks, this formula appears to work correctly.

 

[Aladin Akyurek]

Thanks everyone for your responses.

I have played around a bit more, and think I've figured this out - there were some blank cells in the Numerical Results Column B which appear to have caused this issue. When I removed the rows with blanks, this formula appears to work correctly.

Why don't you invoke the formula of post #2 instead of removing records?