Hello,

I am trying to set up a standard test form for some data. The way the
data will normally be presented/entered will be like a frequency
distribution as such:

172.60 50
172.70 63
172.80 26
172.90 0
173.00 11
173.10 0

I want to have a block that presents the info in a nutshell - min, max,
range, mode, average, stdev of the above array. So far I have the
average and stdev part working (thanks Wigi!), and the range is simple
max minus min... what I am trying to figure out is how to calculate the
max and min. If the first and last values in column A were non-zero,
it'd be simple. As it is... I'm trying to figure out how to implement
max() when the last couple listed entries may have zero count. It looks
like sumif works about like what I want - i.e. count a cell value only
if it meets a certain parameter. I would think that some form of if()
statement would be in order, but I'll be darned if I could make it work
the first couple go-arounds.

Any help or advice would be greatly welcomed.

Thanks,

Monte