I wondering if there is a way to calculate the STD with data that if the value is 0 then its just not there. For example if the data set was 8,9,4, and 6 but there was a total number of 20 data points. The others are to be considered 0. Is there a way to calculate the STD without having to input all the 0's? I planned on using the STDEV.S function.