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!