Suppose you have data table with about ten different parameters, and you wish to calculate the average of each column in the table along with the standard deviation (for the entire population of the existing table).

Unfortunately, not all the parameters are measured on each date in the table and there are blank gaps in the data.

I used AVERAGEIF(Table1[parameter],crit) where crit is a defined name:>0

Next I used STDEV.S(Table1[parameter]) for the standard deviation.

Is this the correct way to ignore the blank records?

1## Re: Statistics on an Excel Data Table