averaging a column

  • Thread starter Thread starter Derrell Teat
  • Start date Start date
D

Derrell Teat

I have a column with different values
.02 <4
<.05
4
1
Click to expand...
<1

How can I total & average these?

Also how can I enter a >4 value in a column & not have it reconized as
math formula?

Thanks,
Derrell
 
In Excel 2000 and Excel XP (and I suspect all other versions) with
default Options settings, if you enter >4 it is interpreted as text, not
a formula. However, when you want text and Excel is not cooperating,
prefix with a single quote.

If the data that you are trying to total and average is constrained to
be nonnegative, then a lower bound for the total is
=SUM(A1:A5)
and
=SUM(IF(LEFT(A1:A5,1)="<",VALUE(RIGHT(A1:A5,LEN(A1:A5)-1)),A1:A5))
array entered (Ctrl-Shift-Enter) is an upper bound for the total.

Divide each by COUNTA(A1:A5) to get bounds for the average.

Your data looks highly unusual for this kind of analysis, since your
data claims that 0.02 was quantitated exactly, while in one instance 4
was not.

Jerry
 
Back
Top