I am trying to determine the average, stdev, min, max of a column of data that contains #N/A (empty) cells. I'd just like to ignore all the #N/As in the column.

How best to do this?

Here's a sample
0:00:03
0:00:07
#N/A
#N/A
0:1:09
0:1:16

I tried =AVERAGE(IF(ISNUMBER(P2:P65), P2:P65)), but I think that is not calculating anything if a single #N/A is found.

Thanks!