Getting Min/Max/Average but cutting out data

B

benallen105

Hi
I have some data which I need to get results for the min, max and % o
msg <= created within 0.2 sec

I know how to get those results from all the data I have, but I need t
cut out the data which is outside of the 0.2 sec range. How do I g
about that

The data I have is formatted like this

0.06
0.08
0.08
0.06
19.72
0.07
0.08
0.09
4.69

So for instance I'd need to cut out 19.722 and 4.696 but everthing els
is ok

I might add - can you get a percentage total of all the data that i
within the boundaries also

Thanks :
 
D

Don Guillett

=AVERAGE(IF($I$1:$I$9<1,$I$1:$I$9))
This an array formula that must be entered using ctrl+shift+enter
Same with min & max
If?? I understand the % request=78% or 1-=22%
=COUNTIF(I1:I9,"<1")/9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top