M

#### Monte Milanuk

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