AVERAGEIF and STDEV ignoring errors

Hi everyone,

So I have a large dataset in which I need to calculate the average and standard deviation of a particular column (X:X) with the condition that another column meets a certain criteria (V:V, "=1").

I tried to use =AVERAGEIF(X:X,"=1",V:V) and {=STDEV(IF(V:V=1),X:X))}, but am getting #N/A in return.

I think the issue may be that the X:X column contains few cells with errors (#N/A) within the range.

So in summary: is there a way to calculate the average and standard deviation for X:X with the condition that V:V meets the criteria of holding numerical value 1, while ignoring the cells in X:X with error values?

Thank you so much for your help in advance!

Hm, I tried that, and still got #N/A again for the average and #DIV/0 for the standard deviation.

FYI:
For another criterion (V:V>1), the original averageif and stdev (CSE for stdev)formulas I tried seem to work fine. For example, =AVERAGEIF(V:V,">1",X:X)gives a value, as well as {=STDEV(IF(V:V>1),X:X))}. I noticed that for these rows where column V is greater than 1, there happen to be no #N/A errors in the column X. In other words, the only times the X:X column has #N/A error happened to be when V:V=1. This is why I assumed that it was the #N/A errors in the X column that was causing the trouble.


Thank you so much for your help!

I've attached a sample here.
Basically, I would like to calculate the average Score and its standard deviation with the condition that there is a "1" in the first column. Thanks again!

Ahhhhh it worked perfectly for the sample dataset (thank you! I was so excited for a moment), but for some reason, error still shows up in the original document (which is only different in that it has 1300+ rows).